How to: Script Jobs Using Transact-SQL (SQL Server Management Studio)
This topic explains how to create Transact-SQL scripts that perform job steps.
To script jobs using Transact-SQL
In Object Explorer, connect to an instance of the Microsoft SQL Server Database Engine, and then expand that instance.
Expand SQL Server Agent, expand Jobs, right-click the job you want to script.
From the right-click menu, select Script Job as, then CREATE To or DROP To and click one of the following:
- New Query Editor Window, which opens a new Query Editor window and writes the Transact-SQL script to it.
- File, which saves the Transact-SQL script to a file.
- Clipboard, which saves the Transact-SQL script to the Clipboard.