What am I missing ?
I have a number of scheduled agent to send email reminders to users. Whenever any of these agents execute, they abend with the error that the Server is not responding, although the server is clearly running.
I have run these agents on other servers with no problems.
What am I missing on the current server setup ?
Thanks for your help.
Tom
Subject: Server Not Responding when Scheduled Agent executes
Do you have a type on a statically assigned server name?
Try using db.servername to get your servernames. That way the code moves more easily from server replica to replica.
Shawn
Subject: RE: Server Not Responding when Scheduled Agent executes
In the ACL I have LocalDomainServers as a server group listed, not the specific server name / type.
Subject: Server Not Responding when Scheduled Agent executes
What server is not responding? Is it the same server the agent is running on? If your agent is trying to open a database on some other server you have to set up a trusted server relationship. Or just run the agent on that server instead.
Subject: RE: Server Not Responding when Scheduled Agent executes
It says that the server that the agent is running on is not responding…
Subject: RE: Server Not Responding when Scheduled Agent executes
Can you post the agent code?
Shawn
Subject: RE: Server Not Responding when Scheduled Agent executes
I put Print statements in the agent, so the log would show me exactly what was executed, and where the error occurred.
The Server Not Responding occurs when I do the doc.send (False).
The code prior to it just builds the Memo form. I only get the not responding when the agent executes on schedule, if I run it myself, it works fine.