Pass Exit code from SQL Job Step

• Fred Woolverton-442598

  Right there with Babe

  Points: 715

  More actions

  June 7, 2007 at 1:31 pm

  #117492

  I want to run a test on a certain table to see if a value exists:

  IF EXISTS

  ((SELECT 1 FROM MTDC_ADMIN..DBAvailabilityAlert

  WHERE InstanceName like @instancename AND FailedFlag like 'F') >=1)

  IF the value is 1 as above, I want the job step to end with Success

  IF the value is anything other than 1 I want the job step to end with Failure.

  Then I can point the job toward the next appropriate step.

  Unfortunately the job reports success no matter what the value.

  Is there any way to pass an exit code to SQL Server?

  FWoolverton

• JacekO

  SSCertifiable

  Points: 6610

  More actions

  June 7, 2007 at 2:07 pm

  #711523

  Just use RAISERROR in the second case. This is going to force the Scheduler to end the step with a failure.

  ---------------------------------------------
  [font="Verdana"]Nothing is impossible.
  It is just a matter of time and money.[/font]