Scripting Jobs Using Transact-SQL

You can generate Transact-SQL scripts to create the jobs that you have defined. With job scripting, you can:

• Control versions of job creation source code.
• Migrate jobs from test into production.
• Script alerts and operators.

To script jobs using Transact-SQL