InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 10:35:26 GMT20http://www.sqlservercentral.com/Forums/Topic573013-146-1.aspxMy recommendation is to use SSMS a newer flavor the better. use the Object Explorer Details. This allows you to highlight multiple objects. Click on the Jobs tree on the server and the jobs will appear in Object Explorer Details. Run the task to create script. With minor editing you should be able to recreate jobs.Good luck.Thu, 06 Dec 2012 10:49:38 GMTerikskinnerhttp://www.sqlservercentral.com/Forums/Topic573013-146-1.aspxcreate a simple ssis package in which you have a tool called "transfer job task" , if you want you can pick the jobs or you can select all. and run the package ... boom all your 150 jobs will be transffed with in a min or 2 .Tue, 08 Feb 2011 12:58:04 GMTaltitude00http://www.sqlservercentral.com/Forums/Topic573013-146-1.aspxIf you have anything that's server specific, such as operator names for email notification, then make sure they already exist on the target server. You can script them out & copy them first.Mon, 22 Sep 2008 12:57:36 GMThomebrew01http://www.sqlservercentral.com/Forums/Topic573013-146-1.aspxRe: scripting jobs, you can script all the jobs in an instance into one file in SSMS if you click on "Jobs" in Object Explorer then highlight all the jobs in the Details panel, right-click and select "Script Job As...".Then you only have one script to run in the Server B.Mon, 22 Sep 2008 09:50:19 GMTGreg Charleshttp://www.sqlservercentral.com/Forums/Topic573013-146-1.aspxI believe you can use the copy database wizard to move jobs.Just set up a 'sacrificial' database, right click -- tasks -- copy databaseRun through the Wizard and I think you have the option to select agent jobs to copy.~CraigCraig OutcaltMCITP, MCDBASun, 21 Sep 2008 08:31:03 GMTSQLBOThttp://www.sqlservercentral.com/Forums/Topic573013-146-1.aspxThere are more than 150 Jobs are running, this is painfull task to copy the each jobs and pasting at the destination servers.I am using SQL Servef 2005 64 Bit and couldn't do multiple select also.Is there any script which will generate script for the jobs.Regards,Mohanraj JayaramanSun, 21 Sep 2008 05:17:59 GMTNew2SQL-343122http://www.sqlservercentral.com/Forums/Topic573013-146-1.aspxScript all the jobs using Management studio in Server A and apply the script in Server BMake sure the output path is validSat, 20 Sep 2008 12:19:38 GMTKrishnaraj9http://www.sqlservercentral.com/Forums/Topic573013-146-1.aspxHi,How to export SQL Jobs which under SQL Server Agent -> Jobs -> (All the jobs).Just want to export these jobs from Server A to Server B.I have already tried with msdb but unfortunatly it had failed to restored it.Thanks in advance for any inputs.Regards,Mohanraj JayaramanSat, 20 Sep 2008 09:17:20 GMTNew2SQL-343122