I am trying to create replication subscriptions to and SQL Server 2008 R2 via a script. There are 3 subscribers so this script creates the subscriptions by calling


and then


with the required parameters for each subscriber. The only thing I have not accomplished so far is to tell the sp_addmergepushsubscription_agent that I wish to set the PollingInterval to 30 seconds instead of the default 60 seconds. What parameters need to be changed in order to do the trick?


You need to set the PollingInterval Merge Agent parameter in the replication agent profile after you create your subscription and your subscription agent.

Have a look at Work with Replication Agent Profiles.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.