Sdílet prostřednictvím

FrequencyTypes Enum

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Management.Smo.Agent
Assembly:
Microsoft.SqlServer.SqlEnum.dll
Package:
Microsoft.SqlServer.SqlManagementObjects v150.18208.0
Package:
Microsoft.SqlServer.SqlManagementObjects v160.2004021.0

This enumeration supports a bitwise combination of its member values.

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

Fields

Name Value Description
Unknown 0

No schedule frequency, or frequency not applicable.
OneTime 1

Scheduled activity will occur once at a scheduled time or event.
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.
Weekly 8

Schedule is evaluated weekly.
Monthly 16

Schedule is evaluated monthly.
MonthlyRelative 32

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

Scheduled activity is started when SQL Server Agent service starts.
OnIdle 128

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

Applies to