SQL Server Job: Error 14274 MSX Server


When you try to change (delete/renamen/disable..) a SQL Server Job and got the following error:
Error 14274: Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server. The job was not saved.

You should follow the MS Article ID 281642 that tell you to rename the SQL Server to its original name, delete job, change the name back and recreate jobs...

This solution require SQL Server downtime so I tried a workaround.. the unofficial(*) way to fix it require you to change the column Originating_Server from the sysjobs table of the MSDB database.

(*) I don't think it's supported by Microsoft, so be very carefully !
Tags:

About author

Vittorio Pavesi