The FrequencyRelativeInterval property specifies a day relative to the start of a month.
object.FrequencyRelativeInterval [= value]
Part | Description |
---|---|
object | Expression that evaluates to an object in the Applies To list |
value | Long integer specifying a day relative to the start of a month as described in Settings |
The FrequencyRelativeInterval property value is a bit-packed long integer. Specify more than a single value by combining values using an Or.
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 |
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.
Long, enumerated.
Read/write
HRESULT GetFrequencyRelativeInterval
(SQLDMO_FREQRELATIVE_TYPE* pRetVal);
HRESULT SetFrequencyRelativeInterval
(SQLDMO_FREQRELATIVE_TYPE NewValue);