Cannot edit maintenance plan SQL Server 2008 R2

Posted on 2011-10-03
Last Modified: 2012-06-27
I cannot edit my maintenance plans in SQL Server 2008 R2. The plans were created (cleanup task for instance) to search a destination but I now want to change that destination.

The account I am using has all SQL role permissions. When I right click the cleanup task maintenance plan and choose modify, I see a 'history cleanup task' and a 'maintenance cleanup task'. If I right click and edit the 'history cleanup task', I can edit some options and click 'OK' to save but if I do the same with the 'maintenance cleanup task' to change the path to the search folder, the 'OK' button is greyed out so I cannot save it?

Surely I don't have to delete this maintenance plan and recreate?!?
Question by:Mfinch
    LVL 12

    Expert Comment

    login as "sa" and make necessary changes.

    Author Comment

    I did that and it is still the same.....
    LVL 10

    Expert Comment

    check for you user roles in the security object in the server group,
    for clean up task user role should be sysadmin

    Accepted Solution

    I ended up recreating the plan anyway, none of the suggestions worked. sa account never helped and my own accoutn had sysadmin role...

    Author Closing Comment

    solutions provided did not work

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now