Managing SQL Server Agent Jobs

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 (found on the SQL Jobs tab of the Database Monitoring and Maintenance snap-in) lists the SQL Server Agent jobs associated with the selected database.

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”), the duration of the last time the job was run, and a the message generated the last time the job was run. Using the SQL Jobs listing, you may start, schedule, enable, and/or disable each job, depending on its status.

To start a SQL Server Agent job:

1. Click Start in the Start Job column.

To enable/disable a SQL Server Agent job:

1. Clear the Enabled check box in the Enabled column.

To schedule an SQL Server Agent job and change its name:

1. Click Change and make changes as needed in the Job Schedule window.