共用方式為


JobSchedule.FrequencyTypes 屬性

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.

命名空間:  Microsoft.SqlServer.Management.Smo.Agent
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property FrequencyTypes As FrequencyTypes 
    Get 
    Set
'用途
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)

屬性值

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

備註

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.

範例

使用 SQL Server Agent 排程自動管理工作

請參閱

參考

JobSchedule 類別

Microsoft.SqlServer.Management.Smo.Agent 命名空間

其他資源

自動化管理工作 (SQL Server Agent)

sp_add_schedule (Transact-SQL)