ActiveStartTimeOfDay Property
未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能,並規劃修改目前使用這項功能的應用程式。
The ActiveStartTimeOfDay property indicates the first effective time for a schedule.
語法
object.ActiveStartTimeOfDay [=value]
Parts
object
An expression that evaluates to an object in the Applies To list.value
A long integer representing a time.
Data Type
Long
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetActiveStartTimeOfDay(LPLONG pRetVal);
HRESULT SetActiveStartTimeOfDay(LONG NewValue);
備註
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.
[!附註]
When 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.