July 1, 2010 at 8:17 am
Is there a proper way to delete a SQL Server 2005 Maintenance Plan using Management Studio so that its associated jobs will be automatically deleted at the same time? I deleted a Maintenance Plan yesterday (can't remember if I deleted it from Database Engine connection or from Integration Services connection). After deleting the Maintenance Plan I was unable to delete the jobs until I did some Googling and found out I had to delete associated rows from sysmaintplan_log, sysmaintplan_subplans, sysjobschedules, and sysjobs in msdb database. Thanks!
July 1, 2010 at 9:18 am
I just deleted a Maint Plan and it deleted the job automatically.
(SQL 2005 SP3)
July 1, 2010 at 9:25 am
This has been my experience. Delete the plan, the job goes away. It does in 2008 , SP1, just tried it.
July 1, 2010 at 2:15 pm
I was also successful today in deleting a Maintenance Plan and associated jobs in one step. Cannot replicate the problem I was having before. Anyway, thanks for replies.
July 1, 2010 at 2:32 pm
The only time I have seen this problem was in trying to delete a maintenance plan that was created before a server was renamed.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply