February 12, 2013 at 1:14 am
Hi All,
I need your advice to process migrate the SQL SERVER AGENT JOBS from 2000 to 2008. Please advice me which is the best way and how do i do?
Thanks in advance
Satish
February 12, 2013 at 8:29 am
Hi,
Use management studio (2008), connect to your 2000 instance, expand sql agent, right click on a job, Script job as>Create to> File or new query editor window.
Use the generated code and run it on your SQL 2008 and the job is created.
If you have thousands of jobs maybe this isn't the best solution.
February 12, 2013 at 3:14 pm
If you have thousands of jobs just click on the Jobs node in Object Explorer and press F7 to open the Object Explorer Details. Then highlight all the jobs you want to script, right-click and script the jobs to a single query window or file.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply