SQL Jobs Plug-in

If enabled, the SQL Jobs Plug-in is displayed in the Database Monitoring and Maintenance Snap-in as a SQL Jobs tab.

A SQL Server Agent job is a collection of SQL statements that is executed by a SQL Server Agent according to an assigned schedule.

The SQL Server Agent Jobs listing of the SQL Jobs Plug-in lists the SQL Server Agent jobs for the database to which the Database Monitoring and Maintenance Plug-in is attached.

For each SQL Server Agent job, the listing includes the following information: job name, job description, job status (“enabled” or “disabled”), run status (“succeeded” or “failed”), and the duration of the last time the job was run. Using the SQL Jobs listing, you may also start, schedule, enable, and/or disable each job, depending on its status.

Enabling/Disabling a SQL Server Job

1. Locate the Job in the SQL Server Agent Jobs table.
2. Click Enable.

Starting a SQL Server Agent Job

1. Locate the Job in the SQL Server Agent Jobs table.
2. Click Start. The SQL Server Agent Job will start.

Scheduling a SQL Server Agent Job

1. Locate the Job in the SQL Server Agent Jobs table.
2. Click Change. The Job Schedule window will appear.

1. Make alterations to the schedule as needed, using the available options.
2. Click OK when finished.