Alert for batch process not starting in time

Grafana Alerting
,
1

Hello,

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,
case
when EMAIL_SUBJECT like ‘%Cycle%Complete%’ then 2
when EMAIL_SUBJECT like ‘%Start%’ then 1
When EMAIL_SUBJECT like ‘%Failed%’ then 3
end,
ist

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?

Thank you,