共用方式為


JobSchedule.FrequencySubDayTypes 屬性

Gets or sets the unit of time used to specify the interval between scheduled jobs that run during the day.

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

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property FrequencySubDayTypes As FrequencySubDayTypes 
    Get 
    Set
'用途
Dim instance As JobSchedule 
Dim value As FrequencySubDayTypes 

value = instance.FrequencySubDayTypes

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

屬性值

型別:Microsoft.SqlServer.Management.Smo.Agent.FrequencySubDayTypes
A FrequencySubDayTypes object value that specifies the unit of time used to specify the interval between scheduled jobs that run during the day.

備註

The FrequencySubDayInterval has meaning only when the FrequencyTypes property of the JobSchedule object is set to FrequencyType.Daily and the FrequencySubDayTypes property is set to FrequencySubDayType.Hour or FrequencySubDayType.Minute.

For example, to schedule an activity for daily occurrence, every 15 minutes, set FrequencyTypes to FrequencyType.Daily, set FrequencySubDayTypes to FrequencySubDayType.Minute, and set FrequencySubDayInterval to 15.

範例

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

請參閱

參考

JobSchedule 類別

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

其他資源

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

sp_add_schedule (Transact-SQL)