Click here to Skip to main content
15,903,012 members
Articles / Database Development / SQL Server / SQL Server 2008R2

Using SMO to script all SQL jobs for an instance using C#.Net

Rate me:
Please Sign up or sign in to vote.
4.00/5 (6 votes)
25 Jan 2015CPOL1 min read 16.5K   5  
A command line utility to script out all jobs from an instance to be used to transfer jobs to another server/environment or to be deposited in source control.

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Architect
United States United States
Originally started out as an Oracle developer, I moved on to become an Oracle DBA, then became certified on Oracle. Later on I had the opportunity to work on some T-SQL projects in parallel with PL/SQL. After working with SQL Server for some time, I now primary find myself dealing almost exclusively with SQL Server and the Microsoft toolkits/SDKs. I am gainfully employed in the financial services industry as a Senior Data/Database Architect specializing in performance tuning, T-SQL code optimization and evangelizing the use of CLR stored procedures, functions, triggers and UDTs, where appropriate.

Comments and Discussions