Configure background jobs

To review or edit one of the SQL Server maintenance jobs:

1. Open SQL Server Management Studio.

   The SQL Server Management Studio window appears.

2. Expand SQL Server Agent.

3. Expand the Jobs folder under SQL Server Agent.

4. Double click on the job to review or edit.

   The Job Properties dialog displays.

5. Execute one of the following tasks within the dialog:

   • Enable/disable the job

   • Edit the existing job steps

   • Add new steps

   • Remove steps

   • Modify the schedule used for the job

   • Define the Alerts associated with the job

   • Define the actions to occur when the job completes, including Notifications

6. Edit a step by selecting the Step page.

   The Step page appears.

7. Select or double click on the step and click Edit.

   The Job Step Properties dialog appears.

8. Configure the desired properties to determine how the individual step will run.

9. Click OK in any of these dialogs saves the changes and closes the dialog.

   Note: Review Security requirements for SQL Server maintenance jobs for details on security requirements for working with SQL Jobs.