Manage Schedules

Applies to: SQL Server Azure SQL Managed Instance

Important

On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Managed Instance T-SQL differences from SQL Server for details.

Allows you to view and change properties for Microsoft SQL Server Agent job schedules.

Options

Available schedules
Lists the schedules available for this user. Notice that a job and a schedule must have the same owner. Therefore, this list only includes schedules owned by the owner of the job.

Name
Displays the name of the schedule.

Enabled
Select this option to enable the schedule.

Description
Describes the conditions under which the schedule runs the job.

Jobs in schedule
Lists the job numbers attached to the schedule. Click a number to view the properties of the job.

New
Click this button to create a new schedule.

Delete
Click this button to delete the selected schedule.

Properties
Click this button to change the properties of the selected schedule.

See Also

Create and Attach Schedules to Jobs