Thanks Brian, I will ask the SQL DBA whether they have RedGate. Regards

This is a pretty nice solution. I will run it past the SQL DBA and check whether they would agree to this. Thanks

Hi Jeff, we require the success to auto clear the failure events. This clear would then auto resolve the help desk auto generated tickets as well as end the SLA...