Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tooba
Posting Yak Master
224 Posts |
 Posted - 2014-06-14 : 00:27:28
|
| Hi All, Just wondering whats the best way to transfer all SQL Agent Job from one machine to other machine. I know I can create a Scripts (I did), If I execute ALL Jobs Script in new machine. It should't be any issue or have to make any change on script before i execute on new machine?Any help would be great appreciated. Thank You. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-14 : 18:18:44
|
| If you generate the script from one server and run it on another server, it likely will error due to the scheduler uid, just remove that line from each of the jobs (schedule).Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
tooba
Posting Yak Master
224 Posts |
Posted - 2014-06-15 : 01:49:40
|
| Awesome, Thanks for Reply, Do all the folder and sub folders should be same name and same directory on new server, right? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-15 : 14:25:06
|
| It depends what you are trying to do.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
tooba
Posting Yak Master
224 Posts |
Posted - 2014-06-16 : 00:08:14
|
| I am trying to Transfer ALL Agent Job from one machine to other machine. That's why I am asking "Do all the folder and sub folders should be same name and same directory on new Machine? " |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-06-16 : 12:17:58
|
| I am just not sure why the folders and sub folders matter for this task. Are the jobs referring to the file system? You may need to change the output path if you are writing info to files, but it isn't a default option. Just depends how your jobs are setup. It's not something we can answer.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
tooba111
Starting Member
22 Posts |
Posted - 2014-06-16 : 20:57:28
|
| Thanks tikizer, everything looks good! You answer the question. Thanks for your help! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL Agent BackUp
Tara Kizer