Error when creating job

  • I get following error message when I try to create a job:

    TITLE: Microsoft SQL Server Management Studio

    ------------------------------

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

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

    what could be the cause of this? I have sa rights and have created job on the instance before.

  • I have gotten this before. This has happened when my SQL Server 2005 was on SP2 but the SQL Management Studio and its related tools was not.

    Once I applied SP2 for SQL 2005 to my SQL tools the problem went away.

    (Sometimes I forget when to upgrade the servers to also upgrade the server tools on my workstation!)

    JTS

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply