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:
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?
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?
Post a Comment