Hey Thank you so much. But I worked on it and came up with a new one.

/* Stored procedure to hourly monitor stored procedures with Script_id 006, 005,004,006, 001 */

CREATE...

Yes It has to send mail notification if any failure occurs.

select * from (

select j.name

,Run_Date=convert(datetime,convert(varchar(8),jh.run_date))

,duration_in_Secs=jh.run_duration/10000*3600

...

here is the code: any modifications is welcum

select * from (

select j.name

,Run_Date=convert(datetime,convert(varchar(8),jh.run_date))

,duration_in_Secs=jh.run_duration/10000*3600

...

Yeah I understand that but i need help with scripting. here is my code:

select * from (

select j.name

,Run_Date=convert(datetime,convert(varchar(8),jh.run_date))

...