![]() |
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.
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