Share via


JobSchedule.FrequencySubDayTypes Property

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

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property FrequencySubDayTypes As FrequencySubDayTypes 
    Get 
    Set
'Usage
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)

Property Value

Type: 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.

Remarks

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.

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)