Scripting Jobs Using Transact-SQL

SQL Server Management Studio can generate Transact-SQL scripts for existing jobs. Generating job scripts helps you perform tasks such as the following:

  • Controlling versions of job creation source code.
  • Migrating jobs from test into production.
  • Scripting alerts and operators.
  • Saving the scripts in a SQL Server Management Studio Project.

SQL Server Management Studio can create scripts for Microsoft SQL Server 2005 and Microsoft SQL Server 2000. If you choose to create a SQL Server 2000-compatible script, certain SQL Server 2005 features are ignored, such as:

  • Column level collation.
  • User-defined functions, extended properties.
  • INSTEAD OF triggers on tables and views.
  • Indexes on views (indexed views).
  • Indexes on computed columns.
  • Descending indexes.
  • Reference permissions on views.

This option is available only on an instance of SQL Server 2005.

To script jobs using Transact-SQL