Dear All,
I'm currently having an issue with the "Distribution clean up: distribution" job which is a default job created for Replication. Would you please let me know how this issue can be resolved as it is scheduled to run every 5 minutes and keeps failing with the following error message:
NT SERVICE\SQLSERVERAGENT. Could not remove directory '\\DIRECTORY'. Check the security context of xp_cmdshell and close other processes that may be accessing the directory. [SQLSTATE 42000] (Error 20015) Replication-@rowcount_only parameter must be the value 0,1, or 2. 0=7.0 compatible checksum. 1=only check rowcou: agent distribution@rowcount_only parameter must be the value 0,1, or 2. 0=7.0 compatible checksum. 1=only scheduled for retry. Could not clean up the distribution transaction tables. [SQLSTATE 01000] (Message 14152). The step failed.
Thank you in advance!
Those errors are generally caused by the SQL Server service account not having full control to the share used in replication.
Sue