删除Management Data Warehouse (MDW) job失败
- WBOYOriginal
- 2016-06-07 17:36:57895browse
最近在清理一些不用的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技术” 博客，请务必保留此出处
，Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article： 【原创】 POSTGRESQL 与MYSQL 实现分割字符串的方法对比Next article： 【原创】PostgreSQL 增量备份详解以及相关示例