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'
GO
EXEC sp_changepublication
@publication = 'your_publication_name',
@property = 'immediate_sync',
@value = 'false'
Answer :
Right click distributor job and change its schedule.
