CODEWITHSUNDEEP
sql-serversql-server-2012maintenance-plan
Oxon
Oxon

Reputation: 5041

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

Upvotes: 43

Views: 22714

Answers (3)

user35762
user35762

Reputation: 1526

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

Upvotes: 141

joeldub
joeldub

Reputation: 57

Restarting SSMS worked for me. I had a hidden dialog stuck in the back ground.

Upvotes: 3

Oussama Saissi
Oussama Saissi

Reputation: 56

Just try to restart SQL Management Studio

Upvotes: 4

Related Questions