Description
I had a customer that wanted to get an alert when a job failed, but also when the job ran successfully again. This is similar to what I call an All-Clear alert, i.e. the problem is no longer happening. To do this, it runs the query and then looks at the current status for each job and compares that to the previous. If the run status is different, it will then trigger this condition. Note the use of "Value Does not equal Last Value" to accomplish this.
Condition Configuration
This Condition can be downloaded and imported into your SQL Sentry installation.