Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Replication Merge: Why is 'Distribution Clean Up: Distribution' disabled by default Expand / Collapse
Posted Monday, January 31, 2011 4:31 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, March 14, 2014 10:34 AM
Points: 36, Visits: 91
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 ( 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.
Post #1056075
Posted Tuesday, November 22, 2011 11:06 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Sunday, August 7, 2016 12:34 PM
Points: 245, Visits: 937
Did you ever find the answer to this? I have the exact same two jobs disabled.

Post #1210396
Posted Tuesday, June 25, 2013 1:42 AM


Group: General Forum Members
Last Login: Thursday, March 6, 2014 1:35 AM
Points: 175, Visits: 547
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.
States that it should be running continuously.
Explicitly ignores this job.

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


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

"Million-to-one chances crop up nine times out of ten." ― Terry Pratchett, Mort
Post #1467016
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse