Unable to Edit/Delete Job
-
I've created/scheduled a maintanence plan to backup a list of selected databases on my test server. I recently renamed two of my databases and wanted to edit the maintanence plan I created to now refer to the new db names. When I try to edit/delete the actual jobs I get the following error:
Error 14274: Cannot add, update, or deleted a job (or its steps or schedules that originated from an MSX server.
I was able to delete the original maintanence plan. I created a new maintance plan to refer to new db names. I now just need to delete the old jobs that are now failing.
Any suggestions?
-
Is this job origination from another server ? (check the "target server(s)" pane when you edit the job)
You could try to alter the job so it only runs local, or you'll have to modify it at your central job server.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Has the server name changed? If so try running this command:
Update msdb.dbo.sysjobs set originating_server = <newserver name> where originating_server = <oldservername>
-
Just throwing out an idea.....
Can you restart the SQL Server Agent and then try to delete it?
Just a random thought.
----------------
Jim P.A little bit of this and a little byte of that can cause bloatware.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply