How to set job step success or failure flow (Enterprise Manager)

How to Install SQL Server 2000

How To

How to set job step success or failure flow (Enterprise Manager)

To set job step success or failure flow

  1. In the details pane, right-click the job, and then click Properties.

  2. Click the Steps tab, click a step, and then click Edit.

  3. Click the Advanced tab.

  4. In the On success action list, click the action to perform if the job step completes successfully.

  5. In the Retry attempts box, enter the number of times from 0 through 9999 that the job step should be repeated before it is considered to have failed. If you entered a value greater than 0 in the Retry attempts box, enter in the Retry interval (minutes) box the number of minutes from 1 through 9999 that must pass before the job step is retried.

  6. In the On failure action list, click the action to perform if the job step fails.