Modifying and Viewing Jobs

Administering SQL Server

Administering SQL Server

Modifying and Viewing Jobs

After you have created a job, you can view the job definition. After you have executed a job, you can view its history. If the requirements of a job change, you can modify the job so that it performs differently.

Note  The job must have been executed at least one time for there to be a job history. You can limit the total size and the size per job of the job history log.

You can modify:

  • Response options.

  • Schedules.

  • Job steps.

  • Ownership.

  • Job category.

  • Target servers (multiserver jobs only).

If you make changes to multiserver job definitions outside of SQL Server Enterprise Manager, you must post the changes to the download list so that target servers can download the updated job again. To ensure that target servers have the most current job definitions, post an INSERT instruction after you update the multiserver job:

EXECUTE sp_post_msx_operation 'INSERT', 'JOB', '<job id>'

You must notify the target servers manually that the job has been modified using the above command after you finish modifying the schedules and steps of a multiserver job using any of the following procedures:

To view a job