[Event Notifications] Simple alert to make sure everything's working.

When I built it, I thought I'd added enough monitors to make sure it didn't break.  Nope!  Someone dropped an endpoint, so things backed up silently for a day and a half.

Add this as a job step on your repository.  For the time, YMMV - 30 is actually too short for me, but 60 should work.

	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 = 'dev@null.com',
	@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

view raw EN_basic_traffic_monitor.sql hosted with ❤ by GitHub

	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 = 'dev@null.com',
	@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

view raw EN_basic_traffic_monitor.sql hosted with ❤ by GitHub