JobSchedule.FrequencyRecurrenceFactor Property

 

Gets or sets the number of weeks or months between scheduled jobs for schedules with a weekly or monthly frequency type, respectively.

Namespace:   Microsoft.SqlServer.Management.Smo.Agent
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public int FrequencyRecurrenceFactor { get; set; }

Property Value

Type: System.Int32

An integer value that specifies the number of units of the unit type indicated by the FrequencyTypes property, which specifies the time between scheduled jobs.

The FrequencyRecurrenceFactor property is evaluated for JobSchedule objects with FrequencyTypes values FrequencyType.Weekly, FrequencyType.Monthly, and FrequencyType.MonthlyRelative.

For example, when FrequencyTypes is FrequencyType.Weekly, FrequencyRecurrenceFactor indicates a number of weeks. Setting FrequencyRecurrenceFactor to 2 specifies that the job is scheduled to occur every other week.

Return to top
Show: