EndRunDate Property

后续版本的 Microsoft SQL Server 将删除该功能。 请避免在新的开发工作中使用该功能,并着手修改当前还在使用该功能的应用程序。

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

语法

object.EndRunDate [=value]

Parts

  • object
    An expression that evaluates to an object in the Applies To list

  • value
    A 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);

注释

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

注意注意

When SQL Distributed Management Objects (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.