• Article

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.

Applies To:

Schedule Object