Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey'

I was getting the following error when I attempted to create a new job in SQL Server Agent:

Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)

Nothing I did improved the situation. It then occured to me that it may not be an issue if I Terminal Severed onto the actual SQL Server.

Presto! It worked and my job was created.

What this complicated error message meant in my case was... "Log onto the box and do it"

I hope you manage to create your job.

Author Ric Hayman MCPD

Ric is an MCPD Microsoft Certified Professional Developer with over 25 years commercial development experience using Microsoft technologies.

Comments

Scott Taylor said:

You're awesome. Worked perfectly by logging into the sql server. Thanks.

04/Dec/2008 20:05 PM

Daniel said:

Thank you for your interpretation. So much easier to understand.

05/Apr/2010 08:17 AM

Polelo said:

Magic!

10/Oct/2012 14:34 PM

Add Comment

Name
Comment
 

Your comment has been received and will be shown once it passes moderation.