• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1301
  • 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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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