Udostępnij za pośrednictwem


NextRunTime Property

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The NextRunTime property returns a system-generated execution time for a SQL Server Agent job.

Syntax

object
.NextRunTime

Parts

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

Data Type

Long

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetNextRunTime(LPLONG pRetVal);

Remarks

The value returned by the NextRunTime property is determined by evaluating all schedules assigned to the job. 0 is a valid return value.

If no schedule is active or no next execution date and time can be calculated, the NextRunDate property returns 0.

Note

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.

Applies To:

Job Object