Udostępnij za pośrednictwem

  • Artykuł

JobSchedule Class

The JobSchedule class represents a SQL Server Agent job schedule.

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

Syntax

'Deklaracja
<SfcElementTypeAttribute("Schedule")> _
Public NotInheritable Class JobSchedule
    Inherits ScheduleBase
    Implements IAlterable, ICreatable, IDroppable, IRenamable, _
    IScriptable

[SfcElementTypeAttribute("Schedule")] 
public sealed class JobSchedule : ScheduleBase, IAlterable, ICreatable, IDroppable, 
    IRenamable, IScriptable

[SfcElementTypeAttribute(L"Schedule")] 
public ref class JobSchedule sealed : public ScheduleBase, IAlterable, ICreatable, IDroppable, 
    IRenamable, IScriptable

/** @attribute SfcElementTypeAttribute("Schedule") */ 
public final class JobSchedule extends ScheduleBase implements IAlterable, ICreatable, 
    IDroppable, IRenamable, IScriptable

SfcElementTypeAttribute("Schedule") 
public final class JobSchedule extends ScheduleBase implements IAlterable, ICreatable, 
    IDroppable, IRenamable, IScriptable

Remarks

SQL Server Agent jobs can be scheduled to run by using SQL Server Agent. Jobs can be scheduled to run when SQL Server Agent is enabled, but jobs are not required to be scheduled. They can be run on demand by a sufficiently privileged user. Jobs can have more than one active schedule. SQL Server Agent evaluates all schedules to determine when to run the job. By using the JobSchedule object, you can do the following:

  • Create a schedule for a SQL Server Agent job.

  • Remove a schedule from an existing SQL Server Agent job.

  • Manage job schedules either by enabling a schedule or adjusting run times or frequencies.

To get or set JobSchedule object properties, users must be a member of the SQLAgentUserRole database role on the MSDB database, or be the owner of the job, or be a member of the sysadmin fixed server role.

To create a job schedule, users must be a member of the SQLAgentUserRole database role on the MSDB database, or be a member of the sysadmin fixed server role.

To drop a job schedule, users must be a member of the SQLAgentUserRole database role on the MSDB database, or be a member of the sysadmin fixed server role.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.