I have a scheduled agent (agent1) that run through another agent (agent2) which has a agent:runonserver call - just to trigger it for testing.
I can do a about a dozen calls and the agent runs enabling me to get info and make amendments. However after a while, agent1 refuses to work. Ahent 2 works ok and it appears to make a call to agent1 but agent1 does not run.
I copied the whole database to another server where the agents did run. However, the same thing happened again - they ran for a while and then nothing.
I have checked the server manager for times etc and everything seems to be ok.
Why does the agent stop working all of a sudden?