Sunday, March 25, 2012

Deleting inaccessible Sql server jobs

hi all,
we have renamed a server which had sql server on it, all the databases are
still on it and their is no problem accessing them at all, and now after thi
s
the sql server jobs which were on this machine and were running before the
name was changed are crashing everytime they run, when i tried deleted them
since i dont need them any more it pops up and error, i am not even able to
disabled or modify them as well. Can any one out their tell how i could
delete these jobs from the sql server tables in the database. The error
message that i get evertime i try modifying\ deleting anything on the job 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.
thanksThis problem could be attributable to the originating_server now differing
from the actual server name.
UPDATE msdb..sysjobs SET Originating_Server = Servername
The Microsoft KBase resolution is here :-
http://support.microsoft.com/defaul...b;en-us;Q281642
--
HTH. Ryan
"sameer" <sameer@.discussions.microsoft.com> wrote in message
news:03A8C8C8-2A05-4660-BD88-15EB2B74F164@.microsoft.com...
> hi all,
> we have renamed a server which had sql server on it, all the databases are
> still on it and their is no problem accessing them at all, and now after
> this
> the sql server jobs which were on this machine and were running before the
> name was changed are crashing everytime they run, when i tried deleted
> them
> since i dont need them any more it pops up and error, i am not even able
> to
> disabled or modify them as well. Can any one out their tell how i could
> delete these jobs from the sql server tables in the database. The error
> message that i get evertime i try modifying\ deleting anything on the job
> 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.
> thanks

No comments:

Post a Comment