Error: while creating job in SQL Server 2005 SP2.

• dbajohnny

  SSC Rookie

  Points: 49

  More actions

  April 17, 2008 at 9:17 am

  #379988

  Hi,

  I am unable to create job.

  I got an error while creating job in SQL Server 2005 with SP2.

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

  Any suggestions & Solutions for without again installation of SQl Server 2005.

  Thankns

  John

• GSquared

  SSC Guru

  Points: 260824

  More actions

  April 17, 2008 at 12:04 pm

  #803920

  This page http://forums.microsoft.com/MSDN/ShowPost.aspx?PageIndex=1&SiteID=1&PageID=1&PostID=1366211 has a discussion of this problem and a possible solution.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon