Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Relationship of sysjob[..] tables to each other

Author  Topic 

MGouders
Starting Member

30 Posts

Posted - 2009-09-18 : 12:48:12
Hi,

Trying to understand how sysjobs, sysjobhistory, sysjobsteps, and sysjobactivity relate each and can be utilized to trace back the performance of jobs in regards of when, how long, and if successfully executed or not has brought me to the point to ask for assistance

The purpose of this post is to get an insight of how admins can apply these tables to retrieve a current snapshot of running jobs historical analysis of how jobs have been performing.

Thanks
   

- Advertisement -