The Jobs Tab

The Jobs tab displays details of SQL Backup 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 View menu, click Refresh Connection.

Display

In the first column, indicates that the job was created using SQL Backup version 5. If no icon is shown, the job was created by a previous version of SQL Backup and the server components have not yet been upgraded to SQL Backup 5, or the job was created by another program (such as SQL Server native backup).

In the second column, indicates that the backup will be encrypted.

Type shows the type of activity. An icon is displayed so that you can scan the list easily:

	Full backup
	Differential backup
	Transaction log backup
	File or filegroup backup
	Full, differential, transaction log, file, or filegroup restore

Note that if you have a dark background colour, the colours of the icons do not reverse. For example:

Full backup

Restore

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. For example:

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.

When you click a job in the Jobs tab, the time line view changes to show the activities that correspond to the job. Similarly, when you click a future activity in the time line, its corresponding job is selected in the Jobs tab.

To edit a SQL Backup 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. The edit feature is not available for jobs that do not display the icon.

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.