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:
- sp_add_jobstep
- sp_update_jobstep
- sp_delete_jobstep
- sp_add_jobschedule
- sp_update_jobschedule
- sp_delete_jobschedule
Note It is not necessary to call sp_post_msx_operation after you call sp_update_job or sp_delete_job, because these stored procedures post the required changes to the download list automatically.
To view a job
Transact-SQLTo view the job history
To check the status of a target server
To resize the job history log
To clear the job history log
To modify a job
To modify the target servers for a job
To modify a target server's location
To delete a job
To synchronize target server clocks
To force a target server to poll the master server