Learn more about Toad for SQL Server
at Dell Software

Find solutions and downloads at the
Toad for SQL Server Support Portal

Toad for SQL Server 6.6

Set Advanced Job Step Options

This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.

To set advanced job step options

  1. Select Jobs from the Agent node in the Object Explorer.

  2. Click , and select the Steps page.
  3. Click New and select the Advanced page.

  4. 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.

 

Related Topics

Define Job Properties

Create Job Categories

Define Job Schedules

About Job Steps

Set Job Alerts

of