The specified pull subscription is not configured with a synchronization agnent job.(.Net sqlclient Data Provider)
I got this below error while i am working in Merge Publication in sql server. I have configured merge publication as pull publication in the environment,so obviously the merge agent job created under subscriber server, but suddenly it stopping rolling forward changes to the subscriber and throwing the below mentioned error.
If i try to click on the Start button the above error is coming up. The issue came up because some added a new step in the job properties of steps section and deleted that later, afterwards this issue occuring.
Workaround:
Delete the exising Merge agent job from subscriber server before you are running the below query.
--run
this in subscriber server under pull subscription
exec sp_addmergepullsubscription_agent
@publisher = 'RAMESH',--> Publisher server name here
@publisher_db = 'sample',-->Publisher database name here
@publication = 'MergePub_Sample',-->Publication name here.
@distributor = 'RAMESH\MSSQL2016'-->Distrbutor server name here.
After your run the command you can see the normal behaviour of Merge Agent Synchronization status.
Comments