FrequencySubDayInterval Property
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The FrequencySubDayInterval property specifies the number of units elapsed between one scheduled activity and a second occurrence of the same activity.
Syntax
object
.FrequencySubDayInterval [=value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
A long integer
Data Type
Long
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetFrequencySubDayInterval(LPLONG pRetVal);
HRESULT SetFrequencySubDayInterval(LONG NewValue);
Remarks
FrequencySubDayInterval has meaning only if the FrequencyType property of the Schedule object is SQLDMOFreq_Daily and the FrequencySubDay property is SQLDMOFreqSub_Hour or SQLDMOFreqSub_Minute.
For example, to schedule an activity for daily occurrence, every 15 minutes, set FrequencyType to SQLDMOFreq_Daily, set FrequencySubDay to SQLDMOFreqSub_Minute, and then set FrequencySubDayInterval to 15.