Transferring SQL Jobs from SQL 2005 to SQL 2008 -
Can someone tell me that SQL is the most effective way to move SQL jobs from SQL to SQL 2008 from SQL 2008 . I am currently upgrading my SQL Server 2008. Thanks!
You should try it to generate a script that you can run on your new instance. Or try this manually: After selecting the jobs folder press F7 key, it will bring up the summary panel and select the job you get from there and right click -> script
Comments
Post a Comment