HostWeb Forums » Microsoft Databases » microsoft.public.sqlserver.tools » Error create a Job in SQL Server 2005 SP2

Topic: Error create a Job in SQL Server 2005 SP2

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 5/30/2008 9:55:03 AM

By: Anonymous

I have the follwing error message when I try to create a Job in SQL Server 2005

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

Someone have a solution for this error?

Thanks in advance

Replies below ↓

Replies

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 5/30/2008 10:38:27 AM

By: Aaron Bertrand [SQL Server MVP]

Re: Error create a Job in SQL Server 2005 SP2

Are you sure your client tools are patched to the same version as the
server? What does the version field say in Help|About for Management
Studio? And how about SELECT @@VERSION for the instance where you are
trying to create the job?

On 5/30/08 11:55 AM, in article
44F03C91-8BAC-45CB-A4A8-DA10A5677C94@microsoft.com, "Paulo Pina"
<PauloPina@discussions.microsoft.com> wrote:

> I have the follwing error message when I try to create a Job in SQL Server
> 2005
>
> "Unable to cast object of type
> 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type
> 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'.
> (Microsoft.SqlServer.Smo)"
>
> Someone have a solution for this error?
>
> Thanks in advance
>

Reply | New Topic | This is SPAM | This is Offensive

Submitted: 5/30/2008 1:55:37 PM

By: Subhen

RE: Error create a Job in SQL Server 2005 SP2

I think we are hitting the issue mentioned in the KB940384.A fix for this
problem is available in Cumulative Update Pack 3.

The link for the KB is : http://support.microsoft.com/kb/940384
I am sure updating the SQL server to the suitable CU will resolve your
problem.Please let me know if this helps

--------------------
| >|>|Thread-Topic: Error create a Job in SQL Server 2005 SP2
| >|>|thread-index: AcjCbYYjjatHFHzBSAuWvLaiQKszDQ==
| >|>|X-WBNR-Posting-Host: 207.46.193.207
| >|>|From: =?Utf-8?B?UGF1bG8gUGluYQ==?=
<PauloPina@discussions.microsoft.com>
| >|>|Subject: Error create a Job in SQL Server 2005 SP2
| >|>|Date: Fri, 30 May 2008 08:55:03 -0700
| >|>|Lines: 11
| >|>|Message-ID: <44F03C91-8BAC-45CB-A4A8-DA10A5677C94@microsoft.com>
| >|>|MIME-Version: 1.0
| >|>|Content-Type: text/plain;
| >|>| charset="Utf-8"
| >|>|Content-Transfer-Encoding: 7bit
| >|>|X-Newsreader: Microsoft CDO for Windows 2000
| >|>|Content-Class: urn:content-classes:message
| >|>|Importance: normal
| >|>|Priority: normal
| >|>|X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
| >|>|Newsgroups: microsoft.public.sqlserver.tools
| >|>|Path: TK2MSFTNGHUB02.phx.gbl
| >|>|Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.tools:3045
| >|>|NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| >|>|X-Tomcat-NG: microsoft.public.sqlserver.tools
| >|>|
| >|>|I have the follwing error message when I try to create a Job in SQL
Server 2005
| >|>|
| >|>|"Unable to cast object of type
| >|>|'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type
| >|>|'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'.
| >|>|(Microsoft.SqlServer.Smo)"
| >|>|
| >|>|Someone have a solution for this error?
| >|>|
| >|>|Thanks in advance
| >|>|
| >|>|

Page 1 of 1 Pages