FrequencyRelativeInterval Property
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.