Maintenance Plan not editable

[idd]

Hi

I am using SQL 2005,
-----------------------------------------------------
Summary
Maintenance plans are not showing under database engine under the manangement section, so I cannot view or modify it
-----------------------------------------------------
I had a few maintenance plans on the server and decided it was time to clear them all and replace them with a few up-to-date maintenance plans.

Iinitially when I tried deleting the old plans I could not delete them, I then deleted the folder 'Maintenenace Plans' under the SSIS
stored packages -- MSDB -- Maintenance plans

This then allowed me to delete the maintenance plans in the database engine under
Management -- Maintenance plans

After deleting the old plans, I added a plan using the maintenance plan wizard. The plan was added to the jobs and to the ssis in the following location
stored packages -- MSDB -- Maintenance plans

However the maintenance plan is not showing up under the database engine under
Management -- Maintenance plans.

And because it is not there, I cannot modify the plan or view it to see what it covers (when I want to at a later date)

Has anyone seen this problem before, how do I solve it?

Any help appreciated.

Idd

 

[mrdenny]

Have you recreated the folder? You may need to add the folder back using T/SQL by adding it to the msdb.dbo.sysssispackagefolders folder. It may require the correct folderid to be used. My server shows a guid of "08AA12D5-8F98-4DAB-A4FC-980B150A5DC8". You may have to restore the msdb database to correct this.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[idd]

Thanks for responding Denny,

sorry for the delayed response I have been out of the office for a few days.

I had recreated a folder,
Also I checked the location you mentioned
msdb.dbo.sysssispackagefolders

and that table does not seem to exist, I have also checked this for that folder on another 2005 server and it does not exist there as well.

and other suggestions and help
Idd

 

[idd]

This is still causing me problems, any other ideas

 

[mrdenny]

That may be a new table that came with SQL 2008. I'd say restore the MSDB from tape, or another server and recreate the packages and jobs. Be sure to script out anything from the MSDB that you need to keep (and back it up) first.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog