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

sql server agent jobs Expand / Collapse
Author
Message
Posted Thursday, March 21, 2013 11:06 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 26, 2015 8:20 AM
Points: 64, Visits: 328
Can anyone tell me how can i copy the sql server agent jobs easily from production to test server without schedule?
Does scripting 'create job' script from prod and running it on test works?
Thanks a lot.
Post #1433917
Posted Thursday, March 21, 2013 12:25 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 4:38 PM
Points: 7,284, Visits: 13,118
You can script the jobs from prod using SSMS but note that it will include the schedules.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1433963
Posted Wednesday, March 27, 2013 6:45 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 13, 2015 2:06 AM
Points: 1,218, Visits: 802
Once you generated Script, plz remove the ID ...

Bcoz once u execute the same script on Test , SQL Server of test Environment will generate id.


Post #1435869
Posted Tuesday, April 2, 2013 1:15 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, August 21, 2015 1:15 AM
Points: 629, Visits: 1,418
What that messy text speak above means is that you need to delete the line that sets a guid value for the schedule id and probably the comma on the previous line. Otherwise this is exactly how I move my agent jobs.
If you study the script you can see how to edit it to amend or remove the schedule if you so wish.
Post #1437725
Posted Thursday, April 4, 2013 1:37 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 26, 2015 8:20 AM
Points: 64, Visits: 328
Thanks everyone
Post #1439002
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse