|
Learn more about Toad for SQL Server Find solutions and downloads at the |
|
Toad for SQL Server 6.6 |
To set advanced job step options
Select Jobs from the Agent node in the Object Explorer.
, and select the Steps page. Click New and select the Advanced page.
Complete the fields as necessary. Review the following for additional information:
On Success/ Failure Flow | Specify the action to take if a job succeeds or fails. |
On success action | Select an action to perform when the selected job steps successfully completes. |
On fail action | Select an action to perform when the selected job steps fails. |
Retry attempts | Enter the number of times to retry the job step if it fails. |
Retry interval (minutes) | Enter the number of minutes that should elapse before Toad attempts to re-execute the job step. |
Create Job Categories