JobSchedule.ActiveStartTimeOfDay Property

Gets or sets the time when the job schedule starts for the day.

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

Syntax

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

value = instance.ActiveStartTimeOfDay

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

Property Value

Type: System.TimeSpan
A TimeSpan value that specifies the time of day when the job schedule starts for the day.

Remarks

Scheduled SQL Server Agent jobs can have begin and end times. A job is run only between the begin time and the end time. Alter the ActiveStartTimeOfDay property to set the time at which the schedule goes into effect.

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)