I've written a scheduled agent that does a dblookup to another database on the server. The agent doesn't pull anything from the lookup when run as a scheduled agent.
If I copy the code into a menu agent and run it, it runs fine. And it emails me the dblookup variables it pulls.
I know the agent is running on schedule because it makes changes to the documents before it gets to the dblookup section. But it won't run the dblookup. But a field that it supposed to populate from the dblookup has the followinge error: "you are not authorized to perform that operation."
I have the same issue on the server.
I have a copy of the lookup database on the server and on my local.
I am running 5.12 on workstation and server.