SQL-DMO
Month and Day (Relative Scheduling) Constants (SQLDMO_MONTHDAY_TYPE)
Month and day constants specify part of the most significant portion of a schedule defining an event that occurs on a day relative to the start of a month.
Use SQLDMO_MONTHDAY_TYPE constants to specify a value for the FrequencyInterval property of a Schedule object when the FrequencyType property of the object is SQLDMOFreq_MonthlyRelative.
| Constant | Value | Description |
|---|---|---|
| SQLDMOMonth_Day | 8 | Scheduled activity occurs on an occurrence of a day, such as the first day of the month. |
| SQLDMOMonth_Friday | 6 | Scheduled activity occurs on a Friday. |
| SQLDMOMonth_MaxValid | 10 | SQLDMOMonth_WeekEndDay. |
| SQLDMOMonth_MinValid | 1 | SQLDMOMonth_Sunday. |
| SQLDMOMonth_Monday | 2 | Scheduled activity occurs on a Monday. |
| SQLDMOMonth_Saturday | 7 | Scheduled activity occurs on a Saturday. |
| SQLDMOMonth_Sunday | 1 | Scheduled activity occurs on a Sunday. |
| SQLDMOMonth_Thursday | 5 | Scheduled activity occurs on a Thursday. |
| SQLDMOMonth_Tuesday | 3 | Scheduled activity occurs on a Tuesday. |
| SQLDMOMonth_Unknown | 0 | Bad or invalid value. |
| SQLDMOMonth_Wednesday | 4 | Scheduled activity occurs on a Wednesday. |
| SQLDMOMonth_WeekDay | 9 | Scheduled activity occurs on a week day, from Monday through Friday. |
| SQLDMOMonth_WeekEndDay | 10 | Scheduled activity occurs on a weekend day, Saturday or Sunday. |