FrequencyRecurrenceFactor Property
この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。 新しい開発作業では、この機能の使用を避け、現在この機能を使用しているアプリケーションは修正するようにしてください。
The FrequencyRecurrenceFactor property controls evaluation of the most significant portion of a Microsoft SQL Server schedule.
構文
object.FrequencyRecurrenceFactor [=value]
Parts
object
An expression that evaluates to an object in the Applies To list.value
A long integer greater than or equal to 1 and indicating a number of weeks or months.
Data Type
Long
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetFrequencyRecurrenceFactor(LPLONG pRetVal);
HRESULT SetFrequencyRecurrenceFactor(LONG NewValue);
説明
The FrequencyRecurrenceFactorproperty is evaluated for Schedule objects with FrequencyType values of SQLDMOFreq_Monthly, SQLDMOFreq_MonthlyRelative, or SQLDMOFreq_Weekly.
The FrequencyRecurrenceFactor property indicates a number of units of the unit type indicated by the FrequencyType property. For example, if FrequencyType is SQLDMOFreq_Weekly, FrequencyRecurrenceFactor indicates a number of weeks. Setting FrequencyRecurrenceFactor to 2 indicates an activity scheduled to occur every other week.
FrequencyType value |
Action |
|---|---|
SQLDMOFreq_Monthly |
SetsFrequencyInterval to indicate the day of the month on which the activity occurs. |
SQLDMOFreq_MonthlyRelative |
SetsFrequencyInterval to indicate the single day of the week on which the activity occurs. Sets FrequencyRelativeInterval to indicate the day of the week relative to the start of the month. |
SQLDMOFreq_Weekly |
SetsFrequencyInterval to indicate the day or days of the week on which the activity occurs. |