SQL Server Agent: Unable to cast object of type ‘SimpleObjectKey’ to type ‘JobObjectKey’.
Categories:
SQL Server
Posted:
Jan 09 2009, 09:39 by
admin
I’ve recently ran into this error when trying to create a new job in SQL Server Agent. I’ve read all types of post on this and everyone seems to say to install SP2 and it will fix the problem. Well, if you haven't installed SP2 yet, then you should do so before moving to the next step.
Unable to cast object of type ‘Microsoft.SqlServer.Management.Smo.SimpleObjectKey’ to type ‘Microsoft.SqlServer.Management.Smo.Agent.JobOjectKey’. (Microsoft.SqlServer.Smo)
To solve this problem, Log into your Terminal Server Remotely or through the Remote Desktop Utility.
In plain English this error is trying to tell you that you cannot create a Job through the Server Agent if you are not logged into that computer locally.
Once you are logged into the box where SQL Server is located, open SQL Management Studio and create your SQL Job.
It works.