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 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
This 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/default...;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