I don’t work much with older versions of SQL server, but I came across the following error today when trying to disable a scheduled SQL 2000 job while trying to backup a SharePoint Portal Server 2003 database.
Error 14274: Cannot delete a job that originated from an MSX server
This error message has two possible causes: either
- the SQL server is not a standalone server, and this message is appropriate, or
- the name of the SQL server has changed since the scheduled job was created.
In my case, the scheduled job had been around for over 6 years, and the server had been renamed about 5 years ago. The job has continued to run and noone needed to make changes to it.
I looked in the sysjobs table in the msdb database and noticed that in the originating_server field, the old server name was still there. I updated each of them with the following statement:
UPDATE sysjobs SET originating_server='yourNewServerName'
and all was well.