How to make sql quit job step fail

Question

I have a sql job step

like this

Declare 
@Result varchar(255)

exec myprocedure
@Result = @Result output

What I want to do:
if @Result = 'Error', then mark the work as failed, how can I achieve this?

Answer 1

Add this to the end of your script:

if @Result = 'Error'
    raiserror('The stored procedure returned an error',16,1)

And make sure that the “Advanced” tab of the step properties has the “on failure” parameter set to “End Job Report Failure”

Answer 2

You can use try catch

Begin Try
   exec myprocedure
   @Result = @Result output
End Try

Begin Catch
   /*Do whatever you want here*/
End Catch