The ActiveStartTimeOfDay property indicates the first effective time for a schedule.
object.ActiveStartTimeOfDay [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to an object in the Applies To list |
| value | Long integer representing a time |
Scheduled SQL Server Agent activities, such as jobs, can have begin and end times. A job is run at the points indicated in a schedule only between the begin time and the end time. Alter the ActiveStartTimeOfDay property to set the time at which the schedule becomes effective.
Note When 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.
Long
Read/write
HRESULT GetActiveStartTimeOfDay(LPLONG pRetVal);
HRESULT SetActiveStartTimeOfDay(LONG NewValue);