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. |