Error received saving a newly created job

• calygirl

  SSC Veteran

  Points: 289

  More actions

  February 25, 2010 at 3:45 pm

  #138454

  I created a new job and when I try to save it I get the following error msg:

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

  The server setup:

  SQL Server Standard Ed. w/sp2

  Windows 2003 R2 Standard sp2 64 bit

  Is it an issue with sp2 running on 64 bit? Corrupted file? Should I re-install service pack?

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  February 25, 2010 at 5:28 pm

  #1125306

  I do not know of the details but please check out the following articles:

  Microsoft.SqlServer.Management.Smo.SimpleObjectKey' ... etc

  http://iamberke.com/archive/2007/08/25/unable-to-cast-object-of-type-microsoft-sqlserver-management-smo-simpleobjectkey-etc.aspx

  Can not create Job on SQL2005

  http://social.msdn.microsoft.com/forums/en-US/sqlsmoanddmo/thread/79281b89-d305-44cc-9568-5dcff4620196/

  Unable to create agent job after installing service pack 2.

  https://connect.microsoft.com/SQLServer/feedback/details/271328/unable-to-create-agent-job-after-installing-service-pack-2

  http://www.sqlservercentral.com/Forums/Topic384975-149-1.aspx#bm835905

  http://www.sqlmonster.com/Uwe/Forum.aspx/sql-server-clustering/3393/Unable-to-Cast-Object

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/