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?!?