JobSchedule.ActiveEndTimeOfDay Property
Gets or sets the time when the job schedule stops 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 ActiveEndTimeOfDay As TimeSpan
Get
Set
'Usage
Dim instance As JobSchedule
Dim value As TimeSpan
value = instance.ActiveEndTimeOfDay
instance.ActiveEndTimeOfDay = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public TimeSpan ActiveEndTimeOfDay { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property TimeSpan ActiveEndTimeOfDay {
TimeSpan get ();
void set (TimeSpan value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member ActiveEndTimeOfDay : TimeSpan with get, set
function get ActiveEndTimeOfDay () : TimeSpan
function set ActiveEndTimeOfDay (value : TimeSpan)
Property Value
Type: System.TimeSpan
A TimeSpan value that specifies the time of day when the job schedule stops.
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 ActiveEndTimeOfDay property to set the time when the schedule is no longer in effect.
Examples
Scheduling Automatic Administrative Tasks in SQL Server Agent
See Also
Reference
Microsoft.SqlServer.Management.Smo.Agent Namespace