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