Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

  • RE: Make SQL Agent job steps fail

    Adi Cohn (9/1/2009)

    I think that severity 16 should also do the trick

    Adi

    Severity 16 has the added advantage of not requiring the elevated rights that severities > 18 necessitate.

    Thanks Adi

    September 1, 2009 at 7:09 am

    #1047488

  • RE: Make SQL Agent job steps fail

    SOLVED

    I have raised the severity of my RAISERROR to > 18 which means it is fatal to the job.

    September 1, 2009 at 6:56 am

    #1047476

Viewing 2 posts - 1 through 3 (of 3 total)