Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Exporting SQL Job Expand / Collapse
Author
Message
Posted Saturday, September 20, 2008 9:17 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 5:11 AM
Points: 52, Visits: 983
Hi,

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 Jayaraman
Post #573013
Posted Saturday, September 20, 2008 12:19 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, May 5, 2014 9:46 AM
Points: 334, Visits: 647
Script all the jobs using Management studio in Server A and apply the script in Server B
Make sure the output path is valid
Post #573041
Posted Sunday, September 21, 2008 5:17 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 10, 2014 5:11 AM
Points: 52, Visits: 983
There 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 Jayaraman
Post #573118
Posted Sunday, September 21, 2008 8:31 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, January 3, 2014 10:59 AM
Points: 626, Visits: 836
I believe you can use the copy database wizard to move jobs.
Just set up a 'sacrificial' database, right click -- tasks -- copy database

Run through the Wizard and I think you have the option to select agent jobs to copy.


~Craig

Craig Outcalt
MCITP, MCDBA


Craig Outcalt



Tips for new DBAs: http://www.sqlservercentral.com/articles/Career/64632
My other articles: http://www.sqlservercentral.com/Authors/Articles/Craig_Outcalt/560258
Post #573131
Posted Monday, September 22, 2008 9:50 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 3:18 PM
Points: 4,065, Visits: 5,284
Re: 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.


Greg
Post #573652
Posted Monday, September 22, 2008 12:57 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, July 26, 2014 8:10 PM
Points: 2,826, Visits: 8,463
If 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.


Post #573789
Posted Tuesday, February 8, 2011 12:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 25, 2014 12:27 PM
Points: 6, Visits: 149
create 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 .
Post #1060582
Posted Thursday, December 6, 2012 10:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 5, 2014 12:07 PM
Points: 2, Visits: 43
My 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.
Post #1393650
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse