Hi, I’m trying to set up alerts, using nrql. This works when triggering an alert, for eg:
SELECT COUNT() FROM Log WHERE logtype = ‘ERROR’
(Query returns a value above 0 at least once in 1 min).
But what I can’t get right is to generate an alert if a function is not running for a certain amount of time.
Query: SELECT count() FROM Log WHERE application = ‘DataRetentionFunction’
Settings: Query returns a value equal to 0 for at least 5 minutes.
I have tried a few variations, but nothing seems to work
It is also strange that the critical violation zone of the graph doesn’t ‘reset’ when my function runs.