• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1382
  • Last Modified:

Cannot edit maintenance plan SQL Server 2008 R2

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?!?
0
Mfinch
Asked:
Mfinch
  • 3
1 Solution
 
viralypatelCommented:
login as "sa" and make necessary changes.
0
 
MfinchAuthor Commented:
I did that and it is still the same.....
0
 
Ramesh Babu VavillaCommented:
check for you user roles in the security object in the server group,
for clean up task user role should be sysadmin
0
 
MfinchAuthor Commented:
I ended up recreating the plan anyway, none of the suggestions worked. sa account never helped and my own accoutn had sysadmin role...
0
 
MfinchAuthor Commented:
solutions provided did not work
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now