yes, other SPs work just fine in the same db. The difference with this one and a typical one, is that it connects to tables on a remote server....

I'm having a very similar problem trying to execute a stored procedure using a job. It runs fine from query analyzer, but fails with Agent. I've checked permissions,...

If you have two SQL servers, you can set up a watchdog between them that will alert you if the other stops responding. It's worked well for me.