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

How to store SQL Server job code and stored procedure in SVN Repository Expand / Collapse
Author
Message
Posted Friday, March 22, 2013 12:13 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 8:17 AM
Points: 29, Visits: 83
what is the best way to store SQL Server jobs code and stored procedure in SVN Repository so that other team members can access it as well


Thanks,
Blyzzard
Post #1434455
Posted Friday, March 22, 2013 12:24 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 9:28 PM
Points: 17,729, Visits: 15,597
Use stored procedures for any jobs and store the stored procedure in SVN

or

Script the job as a drop create and store that statement in SVN.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1434465
Posted Friday, March 22, 2013 12:53 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 8:17 AM
Points: 29, Visits: 83
How to script the job as drop create?
Post #1434481
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse