Thanks for your reply.

The TRY...CATCH block worked so when the stored procedure failed for one program then it skipped to the next one and sent the email. I also used...

Hi Sean,

Sorry I did not replied to you earlier.

The two posts/links that you recommended were very good and helped me a lot to create the reports I needed.

Thank you very...