Script jobs for restore to another server

Hot Topic

SQL Server 2005 and Windows 2000
Displaying values in list from Left-Right instead of Right-Left
Server is 2000, client is 2005: problems!
Report Model - where is it stored?
SQL 2005 becomes unresponsive Help
import flat file
Vertical Line
Set date format in SQL?
Copy cube from a DB to another one
Flat file CSV problem

SQL Server

XML logs without a FileConnection ?
Cannot view packages.
PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE
SQL Native Client automatic failover only works when both servers are plugged in
Dynamic source for Excel file at runtime
Getting Error While Closing and Reopent the Same Report.
Rounding a number
Relative date ---'Rolling 3 months' --help please
Report builder cannot be shown on other user login
SQL 2005 v9.0.2047 (SP1) - The query processor could not produce a query plan

Script jobs for restore to another server

I want to restore all jobs from one server to another. I seem to remember that in SQL 2000 there was an option to script all jobs but it seems that in 2005 you have to script them 1 at a time. Is there a more efficient way than scripting each job and then executing each script individually

Thanks,

-Dave

Answer this question

Script jobs for restore to another server

Jameslee20
you still can. just open the 'summary' window and go to jobs. highlight all the jobs and generate the script.
Script jobs for restore to another server

Answer this question