ActiveStartDate Property
Questa caratteristica verrà rimossa a partire da una delle prossime versioni di Microsoft SQL Server. Evitare di utilizzare questa funzionalità in un nuovo progetto di sviluppo e prevedere interventi di modifica nelle applicazioni in cui è attualmente implementata.
The ActiveStartDate property indicates the first effective date for a schedule.
Sintassi
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);
Osservazioni
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.
[!NOTA]
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.