Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
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 (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.
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: Wednesday, August 20, 2014 10:08 AM
Points: 229, Visits: 805
Did you ever find the answer to this? I have the exact same two jobs disabled.

Thanks.
Patti
Post #1210396
Posted Tuesday, June 25, 2013 1:42 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, March 6, 2014 1:35 AM
Points: 178, 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.

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.

"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