Scheduling Frequency Constants (SQLDMO_FREQUENCY_TYPE)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
Scheduling frequency constants specify SQL Server Agent service evaluation of a scheduled job or replication task.
Constant |
Value |
Description |
|---|---|---|
SQLDMOFreq_Autostart |
64 |
Scheduled activity is started when the SQL Server Agent service starts. |
SQLDMOFreq_Daily |
4 |
The schedule is evaluated daily. |
SQLDMOFreq_Monthly |
16 |
The schedule is evaluated monthly. |
SQLDMOFreq_MonthlyRelative |
32 |
The schedule is evaluated relative to a part of a month, such as the second week. |
SQLDMOFreq_OneTime |
1 |
The scheduled activity occurs once, at a scheduled time or event. |
SQLDMOFreq_OnIdle |
128 |
The SQL Server Agent service schedules the activity for any time during which the processor is idle. |
SQLDMOFreq_Unknown |
0 |
There is no schedule frequency, or the frequency is not applicable. |
SQLDMOFreq_Valid |
255 |
A mask to test schedule frequency validity. |
SQLDMOFreq_Weekly |
8 |
The schedule is evaluated weekly. |