共用方式為


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.