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
 General SQL Server Forums
 New to SQL Server Administration
 How can I create a custom report on job failed?

Author  Topic 

osirisa
Constraint Violating Yak Guru

289 Posts
Posted - 2010-07-22 : 17:13:08
How can I query the system database the status of a job? I need to create a report that pull all job status = failed. Thank you so very much for all your help.

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2010-07-22 : 17:15:10
Check out sysjobhistory in the msdb database. I wouldn't suggest doing it that way though. I'd instead suggest a monitoring package such as Microsoft's MOM/SCOM product or just using the notifications that are available in the jobs.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site