title: Notifications for SQL Job when a step fails
body: <p>Trying to find out if there is a way to setup email notifications when just 1 (or more) steps fail on a sql job.  I have a job with 9 steps, but each step needs to be set to continue to next step even if it fails.  So even when a step fails, because I need it to go to the next step its not set to "report failure". As SQL Server Agent does not have an option for "Report failure and go to next step" I am wondering if anyone has any workarounds for getting a notification</p>