Scheduled agent on replicas to run at different time

Hi,

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.

Is there any way of acheiving this??

Please advise. Thanks in advance.

Best Regards,

Guru

Subject: RE: Scheduled agent on replicas to run at different time

The easiest way is to use two agents. To avoid having copies of the same code, you could put the code in a script library.

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.