When I go to SQL Server Management Studio -> Management -> Maintenance Plans -> Right click on the maintenance plan that I want to execute but the option is greyed out.
To view it, Open SSMS, expand SQL Server Agent, and expand Jobs. You can execute the maintenance plan manually. To do that, right-click the Maintenance Plan and click Execute. The maintenance plan completes successfully.
In Object Explorer, click the plus sign to expand the server where you want to create a maintenance plan. Click the plus sign to expand the Management folder. Right-click the Maintenance Plans folder and select Maintenance Plan Wizard. Follow the steps of the wizard to create a maintenance plan.
Modifying Maintenance Plans You can modify existing Maintenance Plans using the Maintenance Plan Designer. To modify a Maintenance Plan open SSMS then expand the Management node, expand the Maintenance Plans node and double click on the Maintenance Plan that you want to modify.
Just try to restart SQL Management Studio
I had the same problem. Turns out it was an execution window that was buried. It doesn't show as an "open window" when you look at the taskbar at the SSMS icon, so it's deceptive. ALT-TAB your way through the windows and you should find it.
The open windows was:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With