I’m trying to create an alert if one of our batch processes does not start at a particular time (8:00 pm).
I created an alert when the batch process failed :
SELECT $__timeGroup(EMAIL_DATE,‘24h’,0) as time,
when EMAIL_SUBJECT like ‘%Cycle%Complete%’ then 2
when EMAIL_SUBJECT like ‘%Start%’ then 1
When EMAIL_SUBJECT like ‘%Failed%’ then 3
FROM [AuditDB].[dbo].[batchcycle] where $__timeFilter(EMAIL_DATE)
But I’m unable to create an alert - if it did not start by 8:00 PM.
Can someone help me with how I can approach this particular alert in grafana?