We have a daily job that generates traffic that we can see in Metric events.
I am trying to create a condition that will trigger an incident if job has not run.
I am really struggling as to how to set this up as clearly it cannot be a simple condition against a threshold. I have tried working with muting rules but so far to no success and also I tried generating some values for periods when the traffic is not occurring in NRQL e.g. the below but that doesnt return any results (as it is adding a number of null I guess)
SELECT filter(max(newrelic.timeslice.value) , where hourOf(timestamp) rlike r'^[0-9]:00$' or hourOf(timestamp) rlike r'^:00$' ) +filter(max(newrelic.timeslice.value)-min(newrelic.timeslice.value) , where hourOf(timestamp) rlike r'^[2-5]:00$' ) FROM Metric WHERE metricTimesliceName='JMX/queue/irisShiftInformationQueue/EnqueueCount' and entity.guid = 'MTQ1NzMxOHxBUE18QVBQTElDQVRJT058NDgxODU3MDgx' since this week limit max timeseries auto
Any suggestions welcomed