SQLTeam.com | Weblogs | Forums

REPORTS to monitor job history


#1

i am looking reports that monitor log job history of my jobs

or

how can i build report that show my the job and when i click of the job, i can watch all his details of the current job.
(i have job that run multiple in one hour)
for example
i want to show the step_id=0 , and in the hide all other his steps in current sechdual.
i hope that i was understood


#2

This basic functionality is provided via SSMS in the SQL Agent. If you are looking to write your own permutation of this, there are a set of tables located in the MSDB database. Here are a few. You can look up the details in BOL:

  • msdb.dbo.sysjobs
  • msdb.dbo.sysjobhistory
  • msdb.dbo.sysjobsteps
    There is also a stored procedure, sp_help_jobhistory, which supplies some of the data points you listed.