EndRunDate Property

SQL-DMO

SQL-DMO

EndRunDate Property

The EndRunDate property specifies the most recent execution date of a SQL Server Agent job.

Applies To
JobHistoryFilter Object
Syntax

object.EndRunDate [= value]

Part

object

Expression that evaluates to an object in the Applies To list

value

Long integer that specifies a date value as described in Remarks

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetEndRunDate(LPLONG pRetVal);

HRESULT SetEndRunDate(long NewValue);

Remarks

By default, EndRunDate is 0. When 0, the property is not evaluated as part of job history filtering.

Note  When SQL-DMO uses a scaled long integer to represent a date, the integer is built as a sum of the year scaled by 10000, the month scaled by 100, and the day. For example, the date April 19, 1997 is represented by the long integer value 19970419.