Online Documentation for SQL Manager for SQL server

Jobs manager

The Jobs manager allows you to browse the list of jobs and manage them efficiently.

To launch the tool, select the Services | SQL Server Agent | Jobs main menu item, or right-click the host alias in the DB Explorer tree and select the Tasks | Jobs item from the context menu.

The list displays the existing jobs as a grid with the following columns: Job Name, Owner, Status, Category, Description, Enabled, Last Run Status, Last Run Date, Next Run Date, Schedules.

Click a column caption to sort items by values of this column in the ascending or the descending mode.

Hint: Enabled/disabled jobs are differentiated in the list by their icons: icons for disabled jobs are grayed out.

Note: Job events and properties are partially listed within the Job tab of Job Editor.

Right-click an item within the list to call the context menu allowing you to create a new job and specify its properties using Job Editor, start an idle job, stop a running job, edit, delete the selected job, show job history, refresh the list, or show/hide columns of the list. Using the context menu you can also export the list of jobs to any of supported output file formats.

Jobs management tools are also available through the Navigation bar of the Jobs manager.