How to define Transact-SQL job step options (Enterprise Manager)

To define Transact-SQL job step options

1. In the details pane, right-click the job, and then click Properties.
2. In the Job Properties dialog box, click the Steps tab, click a job step, and then click Edit.
3. In the Edit Job Step dialog box on the General tab, be sure the type is Transact-SQL Script (TSQL), and then click the Advanced tab.
4. Enter the name of an output file and decide if the file should be overwritten or appended to.
5. Specify if you want the output included in the steps history. Output will only be shown if there were no errors. Also, output may be truncated.
6. In the Run as user list, click the user (available to system administrators only).