| Author |
Topic |
|
SreenivasBora
Posting Yak Master
164 Posts |
 Posted - 2006-06-26 : 14:49:51
|
| Hi Guys,I want to Transfer/Migrate SQL Server Agent Jobs from One server to Another SQL Server. I DON'T want to manually generate script for each one of job.Can any one suggest me how to transfer the jobs?With RegardsBSR |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-06-26 : 17:52:38
|
| It's not bad to have a tool to script out all the jobs to files. I have one server that has over 200 jobs on it, so scripting out one at a time is a major chore.I agree that you have to look at each one when you move it to another server, but at least it's a start.By the way, the script I linked to has at least 2 bugs in it. If you decide to use it, I am sure you will have just as much fun debugging is as I did. After all, who doesn't love debugging a VB script?CODO ERGO SUM |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2006-06-28 : 14:40:40
|
| I DON'T want to manually generate script for each one of job.With RegardsBSR |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-06-28 : 15:21:59
|
quote:
Originally posted by tkizer
quote:
Originally posted by X002548
Huh?Right click on Jobs, and script them all at once...I am so confused...Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam
It doesn't allow you to script them all at once. It only has functionality to do it one at a time.Tara Kizeraka tduggan
If you follow what Brett said, you can script them all at once (in SQL 2000), but all jobs go together into a single file.CODO ERGO SUM |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-28 : 15:25:15
|
| I guess I haven't seen that option then. Why bother using a different tool if EM can do it?Tara Kizeraka tduggan |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-06-28 : 15:46:36
|
| My experiece in moving jobs from one server to another is that you have to do something for each one, like change path to the output file, change schedule, or something.I usually like to work with one script for one job at a time, but it nice to be able to script out all the jobs to files in one shot.CODO ERGO SUM |
|
|
|
|
How to Transfer SQL Agent Jobs