FrequencyRelativeInterval Property (SQL-DMO)

The FrequencyRelativeInterval property specifies a day relative to the start of a month.

Applies To

Schedule Object

Syntax

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

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

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.

Data Type

Long, enumerated.

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFrequencyRelativeInterval
(SQLDMO_FREQRELATIVE_TYPE* pRetVal);

HRESULT SetFrequencyRelativeInterval
(SQLDMO_FREQRELATIVE_TYPE NewValue);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.