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: Tuesday, January 14, 2014 4:03 PM
Points: 64, Visits: 312
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 @ 7:19 PM
Points: 7,127, Visits: 12,655
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: Tuesday, September 9, 2014 3:03 AM
Points: 1,062, Visits: 708
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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 1:02 AM
Points: 563, Visits: 1,175
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: Tuesday, January 14, 2014 4:03 PM
Points: 64, Visits: 312
Thanks everyone
Post #1439002
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse