Distribution agent cleanup
Recently I encountered a SQL Server 2005 Replication setup where an error message was appearing about every 5 minutes in the SQL Server error logs. The error message was coming from the failing distribution cleanup job. Examining the job history I was able to determine the real error message. The first step in debugging was to confirm if xp_cmdshell was enabled….