Scheduling Relative Frequency Constants (SQLDMO_FREQRELATIVE_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 relative frequency constants specify a schedule subunit as an offset relative to another, greater scheduling unit. For example, a SQL Server Agent service job can be scheduled to occur on the first and third Sunday of every month.
Constant |
Value |
Description |
|---|---|---|
SQLDMOFreqRel_First |
1 |
Schedules an event to occur on the first subunit. |
SQLDMOFreqRel_Fourth |
8 |
Schedules an event to occur on the fourth subunit. |
SQLDMOFreqRel_Last |
16 |
Schedules an event to occur on the last subunit. |
SQLDMOFreqRel_Second |
2 |
Schedules an event to occur on the second subunit. |
SQLDMOFreqRel_Third |
4 |
Schedules an event to occur on the third subunit. |
SQLDMOFreqRel_Unknown |
0 |
Does not schedule relatively, or relative scheduling is not applicable. |
SQLDMOFreqRel_Valid |
31 |
A mask of all valid relative scheduling unit constants. |