ActiveStartDate Property
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
The ActiveStartDate property indicates the first effective date for a schedule.
Sintaxis
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);
Notas
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.