Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)Not good!
The error can have a number of causes. Solutions include:
- Installing SQL Server 2005 SP2 (claimed by a number of individuals to work).
- If you are accessing the SQL Server across a network, logon to the server using remote desktop or similar and attempt to create the job locally.