Scheduling Frequency Constants (SQLDMO_FREQUENCY_TYPE)

SQL-DMO

SQL-DMO

Scheduling Frequency Constants (SQLDMO_FREQUENCY_TYPE)

Scheduling frequency constants specify Microsoft® SQL Server Agent service evaluation of a scheduled job or replication task.

Constant Value Description
SQLDMOFreq_Autostart 64 Scheduled activity is started when SQL Server Agent service starts.
SQLDMOFreq_Daily 4 Schedule is evaluated daily.
SQLDMOFreq_Monthly 16 Schedule is evaluated monthly.
SQLDMOFreq_MonthlyRelative 32 Schedule is evaluated relative to a part of a month, such as the second week.
SQLDMOFreq_OneTime 1 Scheduled activity will occur once at a scheduled time or event.
SQLDMOFreq_OnIdle 128 SQL Server Agent service will schedule the activity for any time during which the processor is idle.
SQLDMOFreq_Unknown 0 No schedule frequency, or frequency not applicable.
SQLDMOFreq_Valid 255 Mask to test schedule frequency validity.
SQLDMOFreq_Weekly 8 Schedule is evaluated weekly.

See Also

FrequencyType Property