FrequencyInterval Property (SQL-DMO)

The FrequencyInterval property defines the most significant portion of a Microsoft® SQL Server™ schedule for daily, weekly, or monthly schedules.

Applies To

Schedule Object

Syntax

object.FrequencyInterval [= value]

Part Description
object Expression that evaluates to an object in the Applies To list
value Long integer specifying a schedule frequency interval as described in Settings

Settings

FrequencyInterval is always interpreted relative to the value of the FrequencyType property. For some FrequencyType values, FrequencyInterval is a bit-packed long integer. FrequencyInterval is interpreted using these values.

FrequencyType value FrequencyInterval value
SQLDMOFreq_Daily Positive, long integer representing a number of day units. For example, when FrequencyInterval is 3, the scheduled activity occurs every third day.
SQLDMOFreq_Weekly Bit-packed long integer. Values are interpreted by using SQLDMO_WEEKDAY_TYPE naming the days of the week. Combine values using an Or to set more than a single day. For example, combine SQLDMOWeek_Tuesday and SQLDMOWeek_Friday to schedule an activity for Tuesday and Friday.
SQLDMOFreq_Monthly Positive, long integer representing the ordinal day of the month on which the schedule is active. For example, 4 specifies the fourth day of the month.
SQLDMOFreq_
    MonthlyRelative
Positive, long integer representing a day of the week or a generic indication of a day. Values are interpreted by using SQLDMO_MONTHDAY_
TYPE.

Remarks

The FrequencyInterval property is valid for Schedule objects with FrequencyType SQLDMOFreq_Daily, SQLDMOFreq_Weekly, SQLDMOFreq_Monthly, or SQLDMOFreq_MonthlyRelative.

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetFrequencyInterval(LPLONG pRetVal);

HRESULT SetFrequencyInterval(LONG NewValue);

  


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