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

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. Click the Steps tab, click a job step, and then click Edit.
   
   
3. Confirm that the job type is Transact-SQL Script (TSQL), and then click the Advanced tab.
   
   
4. Enter the name of an output file, and decide whether the file should be overwritten or appended to.
   
   
5. Select the Append output to step history check box 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).