Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Maintenance Plan Execute option is greyed out

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.

enter image description here

  • I have checked and SQL Server Integration Services is running.
  • I can execute other maintenance plans.
  • I have even tried modifying this plan without an issue but Execute stays greyed out.
  • There is no other instance of the plan running at the moment.
  • I have also disconnected from the SQL Server and connected back but that didn't help either.
  • SQL Agent is running.
like image 732
Oxon Avatar asked Jun 01 '15 12:06

Oxon


People also ask

How do I manually run SQL maintenance plan?

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.

How do I add a maintenance plan in SQL?

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.

How can I change SQL Server 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.


2 Answers

Just try to restart SQL Management Studio

like image 23
Oussama Saissi Avatar answered Sep 18 '22 03:09

Oussama Saissi


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:

the hidden window

like image 125
user35762 Avatar answered Sep 18 '22 03:09

user35762