Page History
...
- On success action - the action to be executed when the step succeeds. You can choose from the following options:
- Go to the next step
- Quit the job reporting success
- Quit the job reporting failure
| Info |
|---|
If you have added steps previously, SQL Enterprise Job Manager allows you to select them on an On |
- Retry attempts - how many times the SQL Server Agent retries a step when it fails
- Retry interval (minutes) - the interval in minutes between each retry
- On failure action - the action to be executed when the step fails. You can choose from the following options:
- Quit the job reporting failure
- Go to next step
- Quit the job reporting success
- Specific options according to the step type you chose before
Options for Operating System (
...
CmdExqec) job steps
When you select selecting an Operating System step type you can specify the additional settings, SQL Enterprise Job Manager allows you to specify additional settings, such as:
- Output file - type an existing file path of the computer where the instance is hosted to be used for the job step. For example D:\Job\outputfile.txt. Then click check click check to verify the path entered is correct.
- Append output to an existing file - enable this option if you want the output to be appended to the output file. If you do not enable this option, the selected file content is overwritten each time the job step runs.
- Log to table - if you select this option, the job step output is logged to the sysjobstepslogs table in the msdb database.
- Append output to existing entry in table - select this option if you want to append the output to the contents of the table. If you do not select this option, the table contents are overwritten each time the job step runs.
- Include step output history - this option lets you include the output of your job step in the job history.
...