SQL Server replication - set PollingInterval in sp_addmergepushsubscription_agent 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

sp_addmergesubscription


and then

sp_addmergepushsubscription_agent


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.