FrequencyRelativeInterval Property
The FrequencyRelativeInterval property specifies a day relative to the start of a month.
Applies To
| Schedule Object |
Syntax
object.FrequencyRelativeInterval [= value]
Part
object
Expression that evaluates to an object in the Applies To list
value
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 | Event scheduled to occur on the first subunit |
| SQLDMOFreqRel_Fourth | 8 | Event scheduled to occur on the fourth subunit |
| SQLDMOFreqRel_Last | 16 | Event scheduled to occur on the last subunit |
| SQLDMOFreqRel_Second | 2 | Event scheduled to occur on the second subunit |
| SQLDMOFreqRel_Third | 4 | Event scheduled to occur on the third subunit |
Remarks
The FrequencyRelativeInterval property is evaluated only when 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 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 set FrequencyRelativeInterval to SQLDMOFreqRel_Last.