 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / July 2008Where are my SQL Server Agent Steps in SQL Server 2005?
I'm trying to migrate from SQL Server 2000 to SQL Server 2005. I've written a number of SQL Server Agent jobs that do database backups every night in SQL Server 2000. I'm trying to copy the steps from these jobs that were created in SQL Server 2000 to corresponding jobs in SQL Server 2005. I am connecting to my SQL Server 2000 database in SQL Server 2005 Management Studio. When I double click SQL Server Agent fot he SQL Server 2000 database in SQL Server 2005 Management Studio, the tree opens up and a list of objects is displayed. When I click the Jobs object, a list of all of the jobs I've created displays. If I right click on one of those jobs, I can select Properties. When I do this, a New Job box pops up as if I want to create a new job. But, I don't, I simply want to display the steps in the current job and copy them to a new job in SQL Server 2005. Could someone tell me what I'm doing wrong? Why don't the steps in the SQL Server 2000 Agent jobs display when one does a properties of them in SQL Server 2005 Management Studio. Thanks in advance. Hi I used to script out SQL Server 2000 jobs and run the script on the new server. > I'm trying to migrate from SQL Server 2000 to SQL Server 2005. I've > written [quoted text clipped - 22 lines] > a properties of them in SQL Server 2005 Management Studio. > Thanks in advance. Uri: Thanks for your response. I tried that. I'm getting an error that says: Unable to cast object of type 'Microsoft.SQLServer.Management. SMO.SimpleObjectKey' to type 'Microsoft.SQLServer.Management.Smo.Agent.JobObjectKey'. (Microsoft.SqlServer.Smo). I get that if I export the SQL Server Agent Job in SQL Server 2000 to a query and then attempt to past the query into an SQL Server Agent job in SQL Server 2005. Any idea what that means? Thanks. > Hi > I used to script out SQL Server 2000 jobs and run the script on the new [quoted text clipped - 26 lines] > > a properties of them in SQL Server 2005 Management Studio. > > Thanks in advance. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.