FrequencyTypes Enum

Definition

This enumeration supports a bitwise combination of its member values.

[System.Flags]
public enum FrequencyTypes
[<System.Flags>]
type FrequencyTypes = 
Public Enum FrequencyTypes
Inheritance
FrequencyTypes
Attributes

Fields

AutoStart 64

Scheduled activity is started when SQL Server Agent service starts.

Daily 4

Schedule is evaluated daily. This has special handling for sub-day types; see the FrequencySubDayTypes enum above that let the schedule run on a second/minute/hour basis during a single day.

Monthly 16

Schedule is evaluated monthly.

MonthlyRelative 32

Schedule is evaluated relative to a part of a month, such as the second week.

OneTime 1

Scheduled activity will occur once at a scheduled time or event.

OnIdle 128

SQL Server Agent service will schedule the activity for any time during which the processor is idle.

Unknown 0

No schedule frequency, or frequency not applicable.

Weekly 8

Schedule is evaluated weekly.

Applies to