Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TallOne
Starting Member
49 Posts |
 Posted - 2007-04-23 : 15:02:35
|
| Hi everyone. My client just updated to SQL Server 2005 SP2. I need to create a job on the server that executes a local exe. But I get error message trying to add a job...any job! I generated the script for the job and copied to the server and it created a skeleton job without my steps! Here is a detailed message I get anytime I try to add a job. I've googled this and haven't found anything helps. Thanks In Advance.===================================Unable to cast object of type 'Microsoft.SqlServer.Management.Smo.SimpleObjectKey' to type 'Microsoft.SqlServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo)------------------------------Program Location: at Microsoft.SqlServer.Management.Smo.Agent.JobCollection.GetObjectByKey(ObjectKeyBase key) at Microsoft.SqlServer.Management.Smo.SimpleObjectCollectionBase.Contains(String name) at Microsoft.SqlServer.Management.SqlManagerUI.JobData.JobExists(String jobName) at Microsoft.SqlServer.Management.SqlManagerUI.JobData.ApplyChanges() at Microsoft.SqlServer.Management.SqlManagerUI.JobPropertySheet.DoPreProcessExecution(RunType runType, ExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(RunType runType) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForSql(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExecutionAwareSqlControlCollection.PreProcessExecution(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult) at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender) |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-23 : 15:16:19
|
| Can you create job in SSMS manually? By the way, better to post this in sql2k5 forum. |
 |
|
|
TallOne
Starting Member
49 Posts |
Posted - 2007-04-23 : 15:18:05
|
I just noticed the wrong forum! Sorry. I'll reply there.  |
|
|
|
|
|
|
New Job Fails SQL 2005 SP2