Error deleting scheduled DTS packagesgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
I have another question for you.
I encountered with the following error message when I tried to delete a scheduled DTS package, the package itself or modifying the schedule of a DTS package: "ERROR 14274:Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server."
What should I do?
Thanks for the answer you provided for my previous question. It didn't quite fulfil what I need to do. But thanks anyway.
-- Anonymous, May 26, 2004
It may be due to renaming the server.
sysjobs has an originating_server column that may be referencing an old server name. This needs to be updated to the new server name.
You can use this procedure assuming @@Servername reflects the new name correctly: http://sqldev.net/download/sqlagent/sp_sqlagent_rename.sql
Hope this helps,
-- Anonymous, May 28, 2004