I need some clarification about the agent scheduled on different replicas.
I have a database with 3 replicas on different servers (Live, Backup & Internal). I also have a schedule agent which runs everyday and archive the documents into Archive database.
My question is
How can I stop the agent running on each replica? It should run only on the Live server.
OR How can I stop the design replication so that when someone replicates the agent properties does not replicate on Backup & Internal server?
In the agent’s design note, click on the Schedule button and select the server this agent should run on.
You could also try to set access levels for all servers to editor, which will effectively stop design changes from being replicated, but sometimes you will wand design changes to be deployed.
It’s sometimes a pain to have to edit the agent and specify which server it should run on and even harder if your design is hidden. My tip would be to add the name of the server which is allowed to run the agent to your database profile document then in the agent get it to check the server name from the profile document, compare it to the server name the database replica is currently on then only continue if they match.