ActiveStartTimeOfDay Property
The ActiveStartTimeOfDay property indicates the first effective time for a schedule.
Applies To
| Schedule Object |
Syntax
object.ActiveStartTimeOfDay [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
Long integer representing a time
Data Type
Long
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetActiveStartTimeOfDay(LPLONG pRetVal);
HRESULT SetActiveStartTimeOfDay(LONG NewValue);
Remarks
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.