All of a sudden the execute option on the maintenance plan properties got greyed out. Here is the back ground.
Our full maintenance plan on SQL server 2008 R2 failed. So I logged in to the server and executed in manually. For some stranage reason I got a failure message but it executed the plan and backed up the databases. And now I wanted to trouble shoot why I got the error though it backed up I noticed that execute option is greyed out.
I have sysadmin rights on the server.
Has anyone faced this before. Suggestions please.