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.