Event Notifications - make sure something's inserted into the table in the last hour. If not, EMAIL.

EN_basic_traffic_monitor.sql

DECLARE @last_insert DATETIME
SET @last_insert = (SELECT TOP 1 insert_datetime FROM EventNotificationRec.dbo.ENAudit_Events ORDER BY id DESC)
SELECT @last_insert

SELECT DATEDIFF(MINUTE,@last_insert, GETDATE())

IF (SELECT DATEDIFF(MINUTE,@last_insert, GETDATE())) >60
begin
EXEC msdb.dbo.sp_send_dbmail
    @profile_name = 'me',
    @recipients = '[email protected]',
    @subject = '[Priority1] Alert! EN is DOWN!',
    @body = 'ALERT!  The Event Notification table has not received any new messages in over an hour.  Investigate immediately.'
end