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 to perform 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:

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>‘

  

After you finish modifying the schedules and steps of a multiserver job using any of the procedures below, you must notify the target servers manually that the job has been modified using the above command.


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

         

To 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

    

See Also
sp_update_job sysjobhistory
sp_delete_jobserver  

 

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.