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.
Document history
7/24/2008 | Initial release. |