共用方式為


LastRunTime Property

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。

The LastRunTime property identifies the most recent time at which SQL Server Agent attempted execution of the referenced job or job step.

語法

object
.LastRunTime

Parts

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

    ms142009.note(zh-tw,SQL.90).gif附註:
    If SQL Distributed Management Objects (SQL-DMO) uses a scaled long integer to represent a time, the integer is built as a sum of the hour scaled by 10000, the minute scaled by 100, and the seconds. The time value uses a 24-hour clock. For example, the time 1:03:09 P.M. is represented by the long integer value 130309.

Data Type

Long

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetLastRunTime(LPLONG pRetVal);

Applies To:

Job Object

JobStep Object