we are using infracture mode classic dashboard.
as there is no option available for exact job failures in AS400, i am trying to use ibm_i.job.instances to assume if job entry is not there then it is aborted/not running. how to find out that .
for example , if there is no job with name contains sys12 , then i want to raise alert .
but any aggregation in this following query, do on instances count .
ibm_i.job.instances:filter(eq(ibm_i_host,"filiali-prd.as400.tntad.fedex.com")):splitBy(ibm_i_host,job_name):partition("pass1",dimension(1,contains(job_name,"SYS12")),otherwise(0)):sum:splitBy(ibm_i_host)
any help or workarounds