Month and Day (Relative Scheduling) Constants (SQLDMO_MONTHDAY_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.
Month and day constants specify part of the most significant portion of a schedule that defines 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 |
The scheduled activity occurs on an occurrence of a day, such as the first day of the month. |
SQLDMOMonth_Friday |
6 |
The scheduled activity occurs on a Friday. |
SQLDMOMonth_MaxValid |
10 |
SQLDMOMonth_WeekEndDay. |
SQLDMOMonth_MinValid |
1 |
SQLDMOMonth_Sunday. |
SQLDMOMonth_Monday |
2 |
The scheduled activity occurs on a Monday. |
SQLDMOMonth_Saturday |
7 |
The scheduled activity occurs on a Saturday. |
SQLDMOMonth_Sunday |
1 |
The scheduled activity occurs on a Sunday. |
SQLDMOMonth_Thursday |
5 |
The scheduled activity occurs on a Thursday. |
SQLDMOMonth_Tuesday |
3 |
The scheduled activity occurs on a Tuesday. |
SQLDMOMonth_Unknown |
0 |
The value is not valid. |
SQLDMOMonth_Wednesday |
4 |
The scheduled activity occurs on a Wednesday. |
SQLDMOMonth_WeekDay |
9 |
The scheduled activity occurs on a weekday that is, a Monday, a Tuesday, a Wednesday, a Thursday, or a Friday). |
SQLDMOMonth_WeekEndDay |
10 |
The scheduled activity occurs on a weekend day (that is, a Saturday or a Sunday). |