Transactional Replication Subscription job does not stop

Hi, I have got one Transaction Replication Set up. Now problem I am facing is that it's subscription job keeps on running once I Start it. It run even if after giving message that there is nothing to replicate now. Anybody has any quick resolutions in mind ?

Help is much appriciated :)

Cheers, Pratik

more ▼

asked Oct 20, 2010 at 05:23 AM in Default

avatar image

31 3 3 3

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You have setup the subscription as a continuous one. This is not a problem in itself, as the commands will be delivered as and when needed. The job will start when the SQL Agent starts and run forever.

If you want to slow down the replication of commands or have them run at a certain time only, then you need to create the subscription and mark it to run at certain intervals. This will then start the agent, run until all uncomitted commands are replicated then stop again.

You can change an existing job if you like too:

You add a schedule to that job with the frequency you require, then change the command that is started by removing "-continuous" from the end of the command string.

Similarly, to reverse this behaviour so that a job runs continuously, you add "-continuous" to the job command string (without the quotes).

more ▼

answered Oct 20, 2010 at 05:27 AM

avatar image

26.2k 18 37 48

Thank you William.. That saved my day

Jul 18, 2012 at 08:26 AM spidydotnet

Hi @Spidydotnot - if my answer solved your problem, please mark the answer as correct. That way anyone searching this site for the same issue will find the solution right here.

Jul 18, 2012 at 09:11 AM WilliamD
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 20, 2010 at 05:23 AM

Seen: 1856 times

Last Updated: Jul 18, 2012 at 09:11 AM

Copyright 2018 Redgate Software. Privacy Policy