Online Documentation for SQL Administrator for SQL Server

Managing schedules


Use this section to schedule subplans defined in the Tasks section.

 

Maintenance plans - Maintenance Plan Editor - Managing schedules

 

 

The grid in the window displays the following information about existing subplans schedules: Name, ID, Enabled, Next Run Time, Description.

 

Using the context menu you can:

  • create a new schedule and add it to the existing subplan
  • edit selected schedule in the Schedule Editor
  • delete selected schedule
  • attach an available schedule to the subplan
  • detach a schedule from the subplan

Alternatively, you can use the 'Insert' button to create a schedule, 'Enter' button to edit schedule(s) and 'Delete' button to drop schedule(s).