Wednesday, May 30, 2007

SQL Failed Jobs report

I went to pull a listing of failed SQL jobs from Operations Manager a while back and found that there is no report to provide this information. I wrote a quick report to gather this information from the Operations Manager data warehouse. Grab the rdl and/ sql script from the links below.

--SQL Failed Jobs SQL query (.sql)

--Failed SQL Jobs report (.rdl)

Jeff

2 comments:

Anonymous said...

Aky: Excellent post Jeff... i got it working! Just had to change the Alert tables name and it worked like charm. Thanks a lot! Can you tell me how did you get the information on table names?

Aky said...

Excellent post Jeff... i got it working! Just had to change the Alert table name value and it worked like charm. Thanks a lot! Can you please tell me so as to how did you get that DB specific information?