Export (0) Print
Expand All
Expand Minimize

Job Step (Advanced Tab)

SQL Server 2000

Use this tab to view or specify the following options.

Options

On success action

Specify the action to perform if the step succeeds.

Retry attempts

Specify the number of retry attempts to be made if the step fails.

Retry interval (minutes)

Specify the interval (in minutes) to wait before retrying the step.

On failure action

Specify the action to perform if the step fails (after performing any retries).

Output file

Specify the file in which to store the results of the Transact-SQL or CmdExec job step. Click the browse (...) button to search for a directory in which to store the output file.

View

Display the selected output file.

Overwrite

Overwrite existing file with the new results.

Append

Add the results to the end of the existing file.

Append output to step history

Add the results of the Transact-SQL job step to the history entry for this step.

Run as user

Allow the system administrator to run the Transact-SQL job step as another database user.

Next

Move to the next step.

Previous

Move to the previous step.

See Also

Creating Job Steps

Handling Multiple Job Steps

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft