Post reply

Distribution Cleanup Creating Blocking

  • August 26, 2005 at 3:20 am

    #165701

    Hi guys,

    I've got  distribution cleanup task running every ten minutes and it keeps creating blocks.  Every ten minutes on the dot is seems to be creating blocks when doing the following:

    EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 72

     

    Any suggestions?  I've disabled the task at the moment.

     

    Cheers,

     

    Iain

  • August 26, 2005 at 8:21 am

    #585429

    Do you need to run it so frequently ?  I run it once a week on the weekend.

  • August 26, 2005 at 8:25 am

    #585434

    Hi ya,

     

    Thanks for the feedback - I've done exactly that

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply