Job Step (Advanced Tab)
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.