Jobs Tab

The Jobs tab displays details of SQL Backup Manager jobs that have been scheduled, and jobs that have been scheduled using SQL Server.

Select the SQL Server instance or database for which you want to see the jobs in the Registered SQL Servers pane.

To update the details, on the File menu, click Refresh Connection.

Display

Dates and times are displayed in the time zone local to the selected SQL Server.

If more than one schedule has been created for a job, the Schedules column shows the number of schedules and you can click to see the individual schedules.

If a job has never been run, Outcome shows Unknown.

Interaction

By default, the jobs are listed in order of the date and time of the last run, with the most recent first. You can change the sort order by clicking the header for the column by which you want to sort the list. Click the header again to reverse the order. You can also resize the columns as required.

To edit a SQL Backup Manager job, right-click the job and click Edit, or double-click the job. The Edit Backup Job wizard is displayed. This is similar to Schedule Backup Jobs, but the wizard contains the settings for the selected job, Step 1 is skipped, and you can edit only one job at a time.

To delete a job, right-click the job and click Delete.

To run a job, right-click the job and click Start.

To stop a job that is running, right-click the job and click Stop. If you click Stop for a job that is not currently running, an error will be displayed.

SQL Server Agent

If the SQL Server Agent for the selected SQL Server instance is not running, a message is displayed at the top of the list, and the list is grayed:

You can start the SQL Server Agent by clicking the Start SQL Server Agent link.