That did the trick! Thanks! I've added additional servers to table Server_SQL_Details for a total of 10. I have one job in failed state on my named instance server.

So I run it with the brackets and I check the Failed_Jobs table and there is one entry, which is good.

Then I run usp_Iterate_FailedJobs procedure and I get this:

(10 row(s) affected)

(1 row(s) affected)

Msg 241, Level 16, State 1, Line 3

Conversion failed when converting datetime from character string.

I check table Failed_Jobs and it is empty. Am I doing something wrong?

Thanks,

Gary