I have a scheduled agent in a database which has repliaces on 2 servers Server A and B.
Server A has manager access to the database and Server B has editor access.
I would like to run the agent at 5 AM on Server A and 12 AM at server B.
If I set the time accordingly on both the replicas, then during the next replication, the agent will have the time as 5 AM on Server B as it will push the changes.
But I would like to run the agent on Server B at 12 am only.
Subject: RE: Scheduled agent on replicas to run at different time
I agree with Andre, another way is to specify not to replicate agents in the replication settings but this might cause more harm than good. You also need to watch out for a template pushing a change to the db.