Error Message while deleting a Job | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error Message while deleting a Job

Hello, I am receiving an error while I try to delete a Job in Enterprise Manager: The error is: Error:14274: Cannot add,update, or delete a job (or its steps or schedules) that
originated from an MSX Server.
We are trying to delete a database job maintenance but it doesn’t let me. Can anybody tell us what we can do to fix this? THANKS.
LUIS
Have you changed the name of your SQL Server recently, or after the creation of this job ? If so, update the ‘originating_server’ column of msdb..sysjobs table with the new server name and then try deleting this job.
You are trying to delete a maintenance plan that has been created in the Master server of the "Multi Server Administration" (MTA).
When you delete a maintenance plan you are actually delete the underlying jobs. You can’t delete the job in the Target server of MTA but you can delete there the maintenance plan. But when you delete that, SQL server tries to delete the job in the target server, which is not possible. You should delete the maintenance plan or its jobs in the Master server. this will automatically delete this plan/jobs from the target server. I hope that will help
Aviel Iluz
Database Administrator
Pacific Micromarketing
Melbourne Australia
www.pacmicro.com.au

Could it be a job that was passed from a Master server to your server? if so it may require deletion from the master prior to being able to remove it from your machine. HTH, Steve
Hey Aviel, us Aussies are quick on the up-take, and you’re obviously quicker than me! HTH, Steve
Refer to this KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;281642 to resolve.
And in future kindly post the thread in relevant forums. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>