Поделиться через

  • Статья

NextRunTime Property

В будущей версии Microsoft SQL Server эта возможность будет удалена. Избегайте использования этой возможности в новых разработках и запланируйте изменение существующих приложений, в которых она применяется.

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

Синтаксис

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);

Замечания

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.

ПримечаниеПримечание

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