FrequencyRelativeInterval Property
Cette fonctionnalité sera supprimée dans une prochaine version de Microsoft SQL Server. Évitez d'utiliser cette fonctionnalité dans de nouveaux travaux de développement et prévoyez de modifier les applications qui utilisent actuellement cette fonctionnalité.
The FrequencyRelativeInterval property specifies a day relative to the start of a month.
Syntaxe
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. |
Notes
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.