How to create a Transact-SQL job step (Enterprise Manager)

To create a Transact-SQL job step

1. Create a job.
2. In the New Job Step dialog box, on the General tab, in Step name, enter a job step name. The maximum number of characters is 128.
3. In the Type list, click Transact-SQL Script (TSQL).
4. In the Database list, click a database for this job step to use.
5. In the Command box, enter the Transact-SQL command batch(es), or click Open to select a Transact-SQL file to use as the command.
6. Click Parse to check your syntax. The message “Parse succeeded” is displayed when your syntax is correct. If an error is found, correct the syntax.

See Also