ActiveStartDate Property
Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.
The ActiveStartDate property indicates the first effective date for a schedule.
구문
object
.ActiveStartDate [=value]
Parts
- object
An expression that evaluates to an object in the Applies To list.
- value
A long integer representing a date.
Data Type
Long
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetActiveStartDate(LPLONG pRetVal);
HRESULT SetActiveStartDate(LONG NewValue);
주의
Scheduled SQL Server Agent activities, such as jobs, can have start and end dates. A job is run at the points indicated in a schedule only between the start date and time and the end date and time. Alter the ActiveStartDate property to set the date at which the schedule becomes effective.
[!참고] When SQL Distributed Management Objects (SQL-DMO) uses a scaled long integer to represent a date, the integer is built as a sum of the year scaled by 10000, the month scaled by 100, and the day. For example, the date April 19, 1998 is represented by the long integer value 19980419.