Hi. I have a scheduled agent that goes through a notes document collection and compares data with some SQL data. At the end of the agent, an email is sent to users listed in a profile field. The agent worked fine until a couple of weeks ago. Now the agent runs, but is not doing the comparison and email. However, when I run the agent manually, everything works. I’m not sure what could have changed since then.
Thanks.
Ed
Subject: Scheduled agent not running
How its it running the SQL? Could it be using an ODBC connection that is no longer working on the server. (But works fine on your PC). Maybe the server was upgraded in some way.
I would add “print” statements before and after each major step in the agent. Then look at the log.nsf the next day on the server to see if every step is being run or if it’s stopping at some point.
Subject: Scheduled agent not running
there are some restrictions when you run the schedule the agent when you save the agent ex 10 am when you schedule it to 2pm it will cehck the time when you saved and when you scheduled
or check for errors in the agent create a log fro your agent and find out the errors