March 7, 2008 at 9:34 pm
Hi all,
Here I am deleting old jobs created by some other person.
But when I am trying to delete this it is giving me error as
Error 14274:Cannot add,update,or delete a job(or its steps or schedules) that orginated from an MSX server. THe job was not saved.
What exactly this error indicates ?
If I Have to delete this jobs then, how I can go ?
Please revert me if anyone knows about this.
Regards
Majid
March 8, 2008 at 3:54 am
For SQL agent you can define a 'master' server which will run jobs on 'slave' servers. sounds like you have that situation here, as you cannot delete the job on the slave server, but have to do it on the master.
Query msdb..sysjobs and see what value is in column 'originating_server', thats the master server the job was created on and thats the server you have to delete the job from.
IF the master server does not exist anymore update the value of originating_server to your local server name and you should be able to delete the job.
---------------------------------------------------------------------
March 9, 2008 at 7:06 am
Yes dear,
it's possible.
I deleted as u said.
Thanks a lot..
Regards
Majid Jafar
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply