Bagikan melalui


JobSchedule.FrequencyTypes Property

Gets or sets the way in which frequency is evaluated for the job schedule, whether it's one time only, or weekly, or when the processor is idle, for example.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property FrequencyTypes As FrequencyTypes 
    Get 
    Set
'Usage
Dim instance As JobSchedule 
Dim value As FrequencyTypes 

value = instance.FrequencyTypes

instance.FrequencyTypes = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public FrequencyTypes FrequencyTypes { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property FrequencyTypes FrequencyTypes {
    FrequencyTypes get ();
    void set (FrequencyTypes value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member FrequencyTypes : FrequencyTypes with get, set
function get FrequencyTypes () : FrequencyTypes 
function set FrequencyTypes (value : FrequencyTypes)

Property Value

Type: Microsoft.SqlServer.Management.Smo.Agent.FrequencyTypes
A FrequencyTypes object value that specifies the way that the frequency of the scheduled job is evaluated.

Remarks

The frequency of the scheduled job can be hourly, daily, weekly, monthly, on certain days of the week that occur in the month, one time only, or when SQL Server starts or is idle, for example.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

See Also

Reference

JobSchedule Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)

sp_add_schedule (Transact-SQL)