Yes Satnam this is very useful, but if any of you have found out how to make this automated to receive an failure message directly when on failure it would be more useful. Should we have any scheduled jobs to kick that msdb exec sp step?
Eben