Job Step (Advanced Tab)
Use this tab to view or specify the following options.
On success action
Specify the action to perform if the step succeeds.
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).
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.
Display the selected output file.
Overwrite existing file with the new results.
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.
Move to the next step.
Move to the previous step.