Make SQL job fail if a DB error is encountered

Discussion created by Jeremy_Clere_7804 on Oct 5, 2016
I have an MS SQL job that is running a query against a MS DB.  The issue I'm having is that when there is a DB error the job does not fail but instead hangs in an active state until the job is manually canceled

there is a an article that explain what to do. Please follow the instruction on this link: