Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.