FrequencySubDayInterval Property (SQL-DMO)

The FrequencySubDayInterval property specifies the number of units elapsed between one scheduled activity and a second occurrence of the same activity.

Applies To

Schedule Object

Syntax

object.FrequencySubDayInterval [= value]

Part Description
object Expression that evaluates to an object in the Applies To list
value Long integer

Remarks

FrequencySubDayInterval has meaning only when 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 set FrequencySubDayInterval to 15.

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFrequencySubDayInterval(LPLONG pRetVal);

HRESULT SetFrequencySubDayInterval(LONG NewValue);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.