x

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 '10 at 05:23 AM in Default

Pratik gravatar image

Pratik
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 '10 at 05:27 AM

WilliamD gravatar image

WilliamD
25.8k 17 19 41

Thank you William.. That saved my day
Jul 18 '12 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 '12 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x293

asked: Oct 20 '10 at 05:23 AM

Seen: 1218 times

Last Updated: Jul 18 '12 at 09:11 AM