Nota
L'accés a aquesta pàgina requereix autorització. Podeu provar d'iniciar la sessió o de canviar els directoris.
L'accés a aquesta pàgina requereix autorització. Podeu provar de canviar els directoris.
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
The FrequencyRelativeInterval property specifies a day relative to the start of a month.
Sintaxis
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. |
Notas
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.