SQL-DMO
Scheduling Relative Frequency Constants (SQLDMO_FREQRELATIVE_TYPE)
Scheduling relative frequency constants specify a schedule subunit as an offset relative to another, greater scheduling unit. For example, a Microsoft® SQL Server Agent service job could 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 | Do not schedule relatively, or relative scheduling not applicable |
| SQLDMOFreqRel_Valid | 31 | Mask of all valid relative scheduling unit constants |