| Jennifer Bates 2002-11-21, 12:24 pm |
| I've seen some posts in here where people have reported getting errors
in SQL 2000 when trying to delete jobs. The actual error is:
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.
Microsoft does give a workaround for this in the article below. There
is an easier way.
http://support.microsoft.com/defaul...kb;en-us;281642
Here's what I did.
If you open query analyzer and run 'select @@servername' you will see
what the server thinks it's name is. Then open the sysjobs table in
the msdb database and check the values in the second column
'originating_server'. If you are getting the error listed about, the
values are probably different than what you got when you ran 'select
@@servername' . All you have to do is change the values in this
column to the correct server name.
I was in a hurry and edited the table directly. We all know that this
is not good practice so you would probably want to do something
like...
use MSDB
update sysjobs
set 'originating_server' = 'correctname'
where 'originating_server' = 'incorrectname'
after that you should be able to delete the jobs. No need to restart
any services.
Jen
|