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 (Monday through Friday) |
| SQLDMOMonth_WeekEndDay | 10 | Scheduled activity occurs on a weekend day (Saturday or Sunday) |