Drew - Great script!
However, similar to Gary I am also getting the conversion error:
Msg 241, Level 16, State 1, Line 2
Conversion failed when converting datetime from character string.
When I bracket and quote the named instance like: ['SERVERNAME\INSTANCENAME'] the SP runs successfully but no failures appear in the table. The weird thing is this works perfectly on my test server but not prod, both are 2005 with no differences that I am aware of.
BTW, the job that failed is not a new job, has been run daily for a few months now. Thanks!!