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.