Replication Merge: Why is 'Distribution Clean Up: Distribution' disabled by default

• AHWB

  Ten Centuries

  Points: 1096

  More actions

  January 31, 2011 at 4:31 am

  #234220

  Note: This applies to SQL server 2005 & 2008.

  I have noticed that when replication merge publication is created SQL also creates the default replication maintenance tasks and all enabled except the following 2:

  •Distribution Clean Up: Distribution

  •Replication monitoring refresher for distribution

  My question is why is ‘Distribution Clean Up: Distribution’ not enabled by default? I have found the following on the Microsoft website as I was trying to identify what each of the tasks do. According to this article (http://msdn.microsoft.com/en-us/library/ms152762.aspx) Distribution Clean Up: Distribution should run Runs every ten minutes – but its disabled, why?

  I’m interested as I have a problem where my distribution db is growing and believe this job should be running.

• Patti Johnson

  SSCertifiable

  Points: 7054

  More actions

  November 22, 2011 at 11:06 am

  #1411706

  Did you ever find the answer to this? I have the exact same two jobs disabled.

  Thanks.

  Patti

• Dennis Post

  SSCarpal Tunnel

  Points: 4473

  More actions

  June 25, 2013 at 1:42 am

  #1627010

  Sorry for bumping a really old post...

  I've been looking into this for a while now but have not managed to find much info.

  http://msdn.microsoft.com/en-us/library/ms152482.aspx

  States that it should be running continuously.

  http://sqlmonitormetrics.red-gate.com/disabled-replication-jobs/

  Explicitly ignores this job.

  What is this job for? Can it / should it be enabled?

  Thanks.

  ---

  
  For better, quicker answers on T-SQL questions, read Jeff Moden's suggestions.[/url]

  "Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort