A short time ago I posted about SQL Server Agent alerts with a follow up post on how to incorporate them into existing alerting functionality that your organisation may have. Today I am going to demonstrate how to do that on one of my local test instances that has been set up along with Sentry One.
First off, Sentry One includes its own SQL Agent job to trap any alerts so essentially what we'll do is replace any notification within the alert and get the alert to run a job instead, in this case the Sentry One trap.
Here's a screen dump of one of the alerts in Management Studio.
Dead simple and of course in this case we wouldn't need to enable database mail as the monitoring application will handle any notifications but if we wanted to retain our mail functionality we can easily do that by ticking the notify operators box and selecting the appropriate operator: