Error deleting scheduled DTS packages

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

hi,

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

Answers

Teoh,

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,

Eric

-- Anonymous, May 28, 2004


Moderation questions? read the FAQ