Viewing and Modifying Jobs
You can view any job you have created. After you have run a job, you can also view its history. Viewing a job's history allows you to see when the job ran, the status of the job as a whole, and the status of each job step in the job. You can see whether the job ever failed in the past, when the job last completed successfully, and what output the job created each time the job ran. Members of the sysadmin fixed server role can view or modify any job, regardless of the owner.
Note
A job must have been executed at least one time for there to be a job history. You can limit the total size of the job history log and the size per job.
Finally, you can modify a job to meet new requirements. You can modify:
- Response options
- Schedules
- Job steps
- Ownership
- Job category
- Target servers (multiserver jobs only)
To make sure that changes to multiserver jobs take effect, you must post the changes to the download list so that target servers can download the updated job. To ensure that target servers have the most current job definitions, post an INSERT instruction after you update the multiserver job as follows:
EXECUTE sp_post_msx_operation 'INSERT', 'JOB', '<job id>'
For more information, see sp_post_msx_operation (Transact-SQL).
Members of the sysadmin fixed server role can view the definition or history of any job, and can modify any job.
To view a job
To view the job history
Resize the job history log
To clear the job history log
To modify a job
To delete a job
See Also
Other Resources
sp_delete_jobserver (Transact-SQL)
sp_update_job (Transact-SQL)
sysjobhistory (Transact-SQL)