Someone asked if error 14274 was prompted: unable to add, update, or delete a job initiated from the MSX Server

Many people ask me if SQLServer server name changed to machine name,Management is a job created when the old name is used. It may encounter error 14274.

Microsoft documents: http://support.microsoft.com/default.aspx? SCID = KB; en-US; 281642

SQLServer2000 MSDB .. sysjobs IN THE SYSTEMInating_serverThe field contains the name of the original server. The system in which the 24x7 instance is used must not change the name as described in the Microsoft document above.

First

UseMSDB

Go

Sp_configure'AllowUpdates ', 1ReconfigureWithOverride

Go

UpdateSysjobsSetOriginating_server =servername

Go

Sp_configure'AllowUpdates ', 0ReconfigureWithOverride

Go

Then delete the job.