Cannot edit SQL Job in Management Studio.

Hello,

In SQL Management Studio, I cannot edit a SQL Job. When I double-click on a sql job or select properties on the context menu, I get a "New Job" window. This was working fine a few days back. Any help will be appreciated.

Thanks,

Ashish.

What happens when you right click and select properties on the job?|||Try installing SQL Server 2005 SP2 on the client. This should solve your problem.|||

I installed SP2 on the client. It didn't help. Thanks for replying back to my post.

Also, we have 3 other developers in the team who are having the same problem.

|||

Thanks for your reply. When I right-click and select properties, I still get the "New Job" window.

|||It could be an issues with SQL tools, have you tried accessing the same job from another client's machine.|||

Hi Satya,

Thanks for your reply. I tried editing the sql job from another computer. I was able to edit it. I know it's issue with the client tools, but cannot figure out to resolve the problem. I installed SP2 on the client side. That also didn't help.

|||You may need to uninstall the client tools, and reinstall them, and also add SP2 again.

Cannot edit maintenance plan created in SQL 2005, SP1

Hello,

I have created a simple maintenance plan in SQL Studio. When I double-click on the task boxes (ie 'Rebuild Index', 'Backup') to just make changes or to look, I get the following message:

Cannot show editor for this task

Additional information:

Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

I also cannot save any change that I make in the schedule of the plan.

I HAVE installed Integration Services, which at least enabled me to initially SAVE the plan. I just can't edit the tasks or change the schedule.

Any help is most appreciated!

Eunice Griffin

I get the same thing - I finally solved all the integration services got to create a backup maint. plan now I can't edit it - what a pain.

Cannot edit maintenance plan created in SQL 2005, SP1

Hello,

I have created a simple maintenance plan in SQL Studio. When I double-click on the task boxes (ie 'Rebuild Index', 'Backup') to just make changes or to look, I get the following message:

Cannot show editor for this task

Additional information:

Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

I also cannot save any change that I make in the schedule of the plan.

I HAVE installed Integration Services, which at least enabled me to initially SAVE the plan. I just can't edit the tasks or change the schedule.

Any help is most appreciated!

Eunice Griffin

I get the same thing - I finally solved all the integration services got to create a backup maint. plan now I can't edit it - what a pain.