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

Copying SQL Server Agent - Jobs Expand / Collapse
Author
Message
Posted Wednesday, January 30, 2008 9:34 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 19, 2009 1:43 PM
Points: 17, Visits: 66
Is there a script that enable the copy of specific sql server agent jobs from one database to another. Thanks for your help in advance....
Post #449509
Posted Wednesday, January 30, 2008 10:48 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 10:51 AM
Points: 14,201, Visits: 28,530
How about right clicking in SSMS and then selecting "Script Job as" and "Create to" to arrive at a script that completely replicates the job, schedule and all.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of:
SQL Server Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #449550
Posted Wednesday, January 30, 2008 3:37 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Saturday, August 25, 2012 9:48 PM
Points: 777, Visits: 134
yaa Grant Fritchey suggestion is the best thing which i also have to suggest.

cheers
sreejith
MCAD
Post #449723
Posted Thursday, January 31, 2008 8:29 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, May 19, 2009 1:43 PM
Points: 17, Visits: 66
Yeah. That worked great. Thanks guys....
Post #449985
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse