Hello,How do I disable an agent on one replica only? And prevent the disabling from being replicated to replica dbs on other servers. I want the agent to run on all the replicas except one.
Many thanks in advance.
Subject: How do I disable an agent on one replica only?
I have seen this question before, but without any acceptable answer.
You could add some extra coding in the agent that checks for the current server. If it is the one you like, call the rest of your code, else do nothing.
Subject: RE: How do I disable an agent on one replica only?
Hi,
If it’s one agent out of severals, then as stated before you need to do some coding.
If it’s the only agent in the DB, you can use the property “Disable background agents for this database” as this property does not replicate.
Hope this helps,
Jean-Louis