Home Forums SQL Server 2008 SQL Server 2008 - General SQL Agent Job succeeds even though step should fail RE: SQL Agent Job succeeds even though step should fail

  • January 6, 2012 at 11:20 am

    #1429773

    azdzn (1/6/2012)

    The step must have "Go to the next step" as "On failure Action".

    See advanced tab in Job STep properties to set up this option.

    There's no must about it. You misunderstand what I'm saying. I'm not talking about the Advanced Actions.

    The job step itself ends with success. It does not fail. It should fail, but it is not failing.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.