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 !
Share on Google Plus

About Vittorio Pavesi

    Blogger Comment
    Facebook Comment

0 commenti: