删除ManagementDataWarehouse(MDW)job失败

最近在清理一些不用的Job,发现几个跟MDW有关的。虽然Job已经被Disable,但是没有被删除。尝试删除出现下面的错误：TheDELETEstatementconflictedwiththeREFERENC.

MDW dbo dbo

datacollector_jobs_cursor 0job_id @job_name

datacollector_jobs_cursor

FK_syscollector_collection_sets_collection_sysjobs

FK_syscollector_collection_sets_upload_sysjobs

0

upload_job_id

0

MDW job

@retVal

tran_cleanup_collection_set

0 0146771

dbo dbo

datacollector_jobs_cursor 0job_id @job_name

datacollector_jobs_cursor FK_syscollector_collection_sets_collection_sysjobs

FK_syscollector_collection_sets_upload_sysjobs

is_running

collection_set_id @TranCounter 0

1 14000

1

END

本文出自 “关注SQL Server技术” 博客，请务必保留此出处