SQL script to find failed Scheduled tasks on multiple DB's 1

[ASAND100]

Can any one point me in the right direction!

I have recently inhereted several SQL 6.5 servers and they all run scheduled maintenace tasks however several are failing.

Can any one point me in the correct direction for creating this script if this is possible!


Thank you

 

[jhall156]

I'm not sure about 6.5 but 2k has a stored procedure sp_help_jobhistory. Check it out in BOL. JHall

 

[jhall156]

Additionally, you want to post in the SQL Server forum. JHall

 

[ASAND100]

You are correct thank you stored procedure for 6.5 is
sp_helphistory

but if I try to run it I get the following! agghhh

Msg 2812, Level 16, State 4
Stored procedure 'sp_helphistory' not found.

Is there any way to confirm if this stored procedure exists in this data base! (put it there if not! thank you!)