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: Today @ 2:33 PM
Points: 40, Visits: 137
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: 2 days ago @ 3:20 PM
Points: 18,064, Visits: 16,099
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
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: Today @ 2:33 PM
Points: 40, Visits: 137
How to script the job as drop create?
Post #1434481
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse