SQL Server 2008 R2 – Change distributor schedule

Posted on

Question :

We have configured SQL Server 2008 R2 replication. Distributor is configured in continuous mode, publisher is scheduler is set to execute after every six hours.

Now we want to change distributor schedule from continuous to schedule frequency without re-creating new replication.

We have tried below stored procedure, but it throws an error. Please help to distributor settings.

EXEC sp_changepublication
@publication = 'your_publication_name',
@property = 'allow_anonymous', 
@value = 'false' 

EXEC sp_changepublication 
@publication = 'your_publication_name',
@property = 'immediate_sync', 
@value = 'false' 

Answer :

Right click distributor job and change its schedule.

enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *