Missing Update to run SQL MaintenanceJob

Question

Hi all,

I tried to run SQL to can Maintenance plan but there is no thing appear when I click to create new Maintenance plan

Server: Windows Server 2008 R2 Standard

SQL: SQL Server 2008 R2 Standard

I think it is a problem of missing Update.

Answer 1

Connect to your sql server and run the following query, post the output in the forum

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Also, make sure you have latest service pack applied on your instance of SQL server.

Answer 2

10.50.1734.0
RTM
Standard Edition (64-bit)

it is the result after installing Cumulative Update 3

Answer 3

Hi Ahmed,

Could you please describe "nothing apear" more detailed? Does it hang or block?

This thread may help you: http://social.msdn.microsoft.com/Forums/en/sqltools/thread/76117d23-0c2d-4bfe-8548-c08921b82a7d

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 4

If I clicked on New Maintenance Plan, Nothing Appear as There is nothing happen and No wizard appear

Answer 5

 Also, I updated it to CU 6

and the result is

10.50.1765.0    RTM    Standard Edition (64-bit)

Answer 6

Ahmed,

Have you ever seen the thread I provided? Suggest you to re-install the Management tools as Charles mentioned. Please follow that thread and I'm waiting for your response.

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 7

Hi Ahmed,

Any progress?

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 8

sorry, it was a long time to say THANKS. it works for me after uninstalling and installing the tools again