FrequencyRelativeInterval Property
Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.
The FrequencyRelativeInterval property specifies a day relative to the start of a month.
구문
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. |
주의
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.