Thanks in advance!
I have several jobs (most scripted in activeX) that I need to move to a different server. Is there an easy way to "copy and paste" them from one server to the other? (SQL7 to SQL2k)Not to copy and paste, however you can create a DTS package to transfer the jobs to another server.
Go to Enterprise manager
Data Transformation Services
Local Package
Local Package
New Package
Under the Task choose 15 - Transfer jobs tasks.
And that should do it.
Lystra|||Or you can script the job, modify the script and run it on the new server with osql, or from QA|||If you right click on the job in question, select All tasks and select "Script Job" (in SQL7) or "Generate SQL Script" (in SQL2k) you can create an SQL script which can be run on the new server via Query analyser. If you want all the jobs to be transferred then right click on jobs and do the same.|||Brett, how do you script a job. Can you please explain.
Thanks
Lystra|||If you right click on the job in question, select All tasks and select "Script Job" (in SQL7) or "Generate SQL Script" (in SQL2k) you can create an SQL script which can be run on the new server via Query analyser. If you want all the jobs to be transferred then right click on jobs and do the same.
Is that good enough?|||I've never tried it from 7.0 to SQL-2000, but can't you just use the File | Save-As menu item?
-PatP|||I've never tried it from 7.0 to SQL-2000, but can't you just use the File | Save-As menu item?
-PatP
?????????????????? ???????|||I created the activeX in note pad first. Then I choose New Job >> Steps >> New>> selected ActiveX and copied and pasted the script. Most of the jobs have more than one step that is why I was hoping to "Copy and Paste" the entire jobs. I have a total of 24 to move to a different server.
Again thanks for the help,
Lee
Showing posts with label job. Show all posts
Showing posts with label job. Show all posts
Subscribe to:
Posts (Atom)