February 4, 2010 at 12:56 pm
All,
I have been able to successfully disable data collection, but when attempting to delete the jobs, I get:
"The delete statement conflicted with the reference constraints fk_syscollector_collection_sets_collection_sysjobs. The conflict occurred in database "msdb", table "dbo.syscollector_collection_sets_internal", column 'collection_job_id'."
Now, I don't want to go through and muck around system tables and constraints ... I could, but I'd like to know if there is a proper method to properly remove data collection all together?
Thank you
February 4, 2010 at 2:20 pm
not at all havent tested it in r2 but here is a connect ticket for it to track https://connect.microsoft.com/SQLServer/feedback/details/334180/data-collector-remove-data-collector-to-remove-associated-objects
February 4, 2010 at 2:22 pm
Great ... well, good to know that it's hopefully being looked at.
Thanks in advance
February 9, 2012 at 9:38 am
Guys,
Take a look at this article. I tested the script out and it appears to work with no ill-effects.
http://blogs.msdn.com/b/sqlagent/archive/2011/07/22/remove-associated-data-collector-jobs.aspx
November 21, 2012 at 5:08 am
Thank you ArloUSA. I had the same issue and the script on the blog post you reference worked perfectly.
December 17, 2012 at 2:49 pm
Thanks a ton..worked for me too.. was struggling to get it off from the server from a long time...Thanks again
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply