Error deleting scheduled DTS packages : 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.

Regards, Teoh

-- 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:

Hope this helps,


-- Anonymous, May 28, 2004

Moderation questions? read the FAQ