| |
 |
What
When you attempt to edit or delete a SQL Server Agent job, you
receive the following error:
| Error 14274: Cannot add, update, or delete a job (or its
steps or schedules) that originated from an MSX
server. |
and you do not have MSX or TSX servers set up.
Why
This is a known issue as reported
here. The
recommended approach is to rename the server to its original name,
script out your jobs, rename the server back again, and recreate
your jobs. There is a faster way that involves modifying the
sysjobs table, so do this only with caution, and after you've
backed up the msdb table.
The reason for the error is because in msdb..sysjobs,
the originating_server
column
contains the old server name, causing SQL Server to think that the
job was created by an MSX server. You can update this column with
the new server name, and SQL Server will then allow you to
edit/delete the jobs again.
Discuss or comment on this article on our Facebook group.
Document history
| 7/24/2008 | Initial release. |
|
