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 |
|
vaidyanathanpc
Starting Member
24 Posts |
 Posted - 2002-06-03 : 09:07:33
|
| Hi, I have about ten jobs running under SQL Server agent on my server. I want to create a script file of three of the jobs to restore on to a different server. I selected all the three jobs -> right click -> generate SQL script. In the script generated, there was only one job scripted. The script was not created for all the three jobs but for only one job. Do I have to generate a script file for each job that I have on my server? Can I not generate a single script file for all the three jobs?Thanks P.C. Vaidyanathan |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-06-03 : 09:14:33
|
| It looks like it's ALL jobs or ONE job via EMIf you highlight one or more jobs it just does the top one.If you highlight no jobs and just right click on the jobs icon under Management in the left hand pane of EM and choose All Tasks>Generate SQl Scripts you get all jobs.HTHJasper Smith |
 |
|
|
|
|
|
Scripting Jobs