GShen,
The job status is actually kept in the msdb.dbo.sysjobhistory table. It's kind of squirrely but you should be able to come up with something. Look in BOL for the sysjobhistory table.
Bill
hoggle,
You are encountering serveral problems with cross server joins. Your temp table resides on the calling server.
Create the temp table on the destination server instead. That way the joined tables will all be on the same server and the query optimizer can create more efficient query...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.