Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
The FrequencyRelativeInterval property specifies a day relative to the start of a month.
Syntax
object
.FrequencyRelativeInterval [=value]
Parts
- object
An expression that evaluates to an object in the Applies To list.
- value
A long integer that specifies a day relative to the start of a month as described in Settings.
Data Type
Long, enumerated
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetFrequencyRelativeInterval
(SQLDMO_FREQRELATIVE_TYPE* pRetVal);
HRESULT SetFrequencyRelativeInterval
(SQLDMO_FREQRELATIVE_TYPE NewValue);
Settings
The FrequencyRelativeInterval property value is a bit-packed long integer. Specify more than a single value by combining values using an OR logical operator.
| Constant | Value | Description |
|---|---|---|
SQLDMOFreqRel_First |
1 |
The event is scheduled to occur on the first subunit. |
SQLDMOFreqRel_Fourth |
8 |
The event is scheduled to occur on the fourth subunit. |
SQLDMOFreqRel_Last |
16 |
The event is scheduled to occur on the last subunit. |
SQLDMOFreqRel_Second |
2 |
The event is scheduled to occur on the second subunit. |
SQLDMOFreqRel_Third |
4 |
The event is scheduled to occur on the third subunit. |
Remarks
The FrequencyRelativeInterval property is evaluated only if the FrequencyType property is SQLDMOFreq_MonthlyRelative.
Set the FrequencyInterval property to indicate the day of week or a generic indication for a day. Then set FrequencyRelativeInterval to specify the relative period from the start of the month.
For example, to schedule an activity for the first and third Thursday of a month, set FrequencyInterval to SQLDMOMonth_Thursday, and then set FrequencyRelativeInterval to SQLDMOFreqRel_First Or SQLDMOFreqRel_Third. To schedule an activity for the last weekday of a month, set FrequencyInterval to SQLDMOMonth_WeekDay and then set FrequencyRelativeInterval to SQLDMOFreqRel_Last.