Merge replication subscription sql agent job not being created

Question

Hi

I am creating a pull subscription by running below code at the end. The subscription gets created but not the sql agent job. What am I missing?

Thanks

Regards

DECLARE @publication AS sysname;
DECLARE @publisher AS sysname;
DECLARE @publicationDB AS sysname;
DECLARE @hostname AS sysname;
SET @publication = N'MYPUB';
SET @publisher = N'MYPUBSERVER';
SET @publicationDB = N'MYPUBDB';

USE [MYPUBDB]
EXEC sp_addmergepullsubscription 
  @publisher = @publisher, 
  @publication = @publication, 
  @publisher_db = @publicationDB;

EXEC sp_addmergepullsubscription_agent 
  @name ='WebSync Agent',  
  @publisher = @publisher, 
  @publisher_db = @publicationDB, 
  @publication = @publication, 
  @distributor = @publisher, 
  @internet_login = 'My Login', 
  @internet_password = 'My PasswordXyzpassabc099',
  @use_web_sync =1, 
  @internet_url = 'https://mydomain.com/SQLReplication/replisapi.dll', 
  @internet_security_mode = 0

Answer 1

Hi,
Try to specify the @hostname parameter in sp_addmergepullsubscription_agent .

Please refer to the official document: Create a Pull Subscription, and pay attention to the required steps and examples.
The last step is to execute the sp_addmergesubscription at the publisher.

Answer 2

Hi Criszhan-m

The subscription as well as the web synchronisation at publisher's end is setup and the web synchronisation url checks out. Its sql agent at the remote sql server subscriber that does not want to create a job in response to sp_addmergepullsubscription_agent. So basically failing at step 3 in the article that you kindly provided.

Thanks

Regards