Online Documentation for SQL Management Studio for SQL Server

Managing scheduled tasks

Task Scheduler allows you to manage your custom tasks configured for scheduled execution.

The list displays the existing scheduled tasks as a grid with the following columns: State, Task Name, Start Date, Last Run Date, Next Run Date, Last Result.

If necessary, you can filter and group the data in grid by any of the columns. The grouping operation is performed by dragging the column header to the gray "Group by" box area at the top. When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back.

Right-click an item within the list to call the context menu allowing you to add a new scheduled task and specify its properties using the Schedule Editor dialog, edit the selected task, delete a task or pause/resume a task that is currently ready/suspended.

You can also use the toolbar buttons to add /edit , pause /resume , or delete an existing scheduled task.

In the Status area at the bottom of the Task Scheduler window you can find brief information pertaining to the currently selected task.

If more convenient, you can use SQL Studio Agent to suspend/launch tasks. Right-click its icon in the system tray area, then select the Suspend Scheduled Task submenu and tick off the task you need. The reverse action is performed in the same way.

Hint: Ready/suspended/launched tasks are differentiated in the Task Scheduler list by their icons in the State column.