Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
ActiveEndTimeOfDay Property

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)

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.Matrix)]
public TimeSpan ActiveEndTimeOfDay { get; set; }

Property Value

Type: TimeSpan
A TimeSpan value that specifies the time of day when the job schedule stops.

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.

Community Additions

ADD
Show:
© 2015 Microsoft