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 |
|
laddu
Constraint Violating Yak Guru
332 Posts |
 Posted - 2008-10-06 : 23:35:48
|
| I have created maintanance plan for backup databases and not able to schedule , throwing the below errorTITLE: 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)Please advice |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-10-07 : 01:54:16
|
I found this at:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1366211&SiteID=1quote:
Here's what I did to get it to work. On our SQL Server 2005 development machine, we did install SP2however, that doesn't solve the problem because the problem lies in scheduling your job using Management Studio through your local machine. If you logged onto your SQL 2005 server that has SP2, you should be able to schedule from there. But it's through Management Studio, which I'm guessing most of you are trying to create a job schedule for your packages. Usually, people don't think of upgrading their client tools as well.I verified this by upgrading my local machine to SP2 for the client tools and was able to successfully schedule. You might also need to upgrade your server machine to SP2 to work as well.
GreetingsWebfredPlanning replaces chance by mistake |
 |
|
|
|
|
|
Backup job maintanance plan