gary.dunn (5/7/2009)

---

Hi Nick, I thought we tried that and it didn't work. I tried it again and now it works?! I must've been doing something wrong. Next question: were you able to get the usp_GetFailedJob stored procedure to work? Here's what I did...I failed a job on my named instance SERVER1\TSTINST1. I also failed a job on a server with just the default instance called SERVER2. I added both servers to the Server_SQL_Details table. I execute usp_GetFailedJob with my named instance server as the parameter (like this - exec usp_GetFailedJob SERVER1\TSTINST1 and it gives an error:

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '\'.

It doesn't like the \. How did you get around that?

Thanks!