Tool for scripting SQL Server Agent Jobs

December 4, 2013 · Posted in SQL, Technology 

I recently created an open-source tool that will create a T-SQL script file containing code to recreate whatever jobs you presently have in SQL Server Agent for any given SQL Instance, up to SQL Server 2012 SP1.

The tool requires SQL Server 2012 SP1 Server Management Objects and SQL Server System CLR Types:

SQL Server System CLR Types (x86)
SQL Server Shared Management Objects (x86)

The tool itself is named MVCTSQLJobScripter and can be downloaded from:

MVCTSQLJobScripter-v1.0-Setup.zip

The utility takes several command-line parameters, as below, which necessitates running it from the command prompt, `cmd.exe`.

MVCTSQLJobScripter.exe /server:localhost /outfile:C:\temp\AgentJobs.sql

The GitHub repository contains the source code for the tool at:

https://github.com/MaxVernon/MVCTSQLJobScripter

As expected, this tool comes with no warranties, express or implied, and is use at-your-own-risk.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

Please answer the anti-spam question: * Time limit is exhausted. Please reload CAPTCHA.