Hi All,
I am having blockings on SQLServer and this job is hanging up all the resources and distribution agents to fail.
EXEC dbo.sp_MSdistribution_cleanup @min_distretention = 0, @max_distretention = 72
I have changed the properties of the distributor to 100 but I dont know how this Sp is running. I could not find a job that determines its running this stored proc as a job. I dont know how to check what is running this job. Please advice asap, would highly appreciate your help. This is Very Urgent.
Is it ok to stop this script from running / what is the best alternative so that I can have other jobs running on the server without being blocked by this job.
Thanks,