Hi ,
My Job completes at 4AM,I need to set up a alert to monitor the job status 2 hours before the job completion time i.e. at 2 AM i should start checking the Job Status if it completed or not,So ...
See more...
Hi ,
My Job completes at 4AM,I need to set up a alert to monitor the job status 2 hours before the job completion time i.e. at 2 AM i should start checking the Job Status if it completed or not,So starting from 2AM i should monitor and trigger the alert till the job is completed.
I am using below query but it doesn't make sense and doesn't satisfies my above condition.
| makeresults
| eval CurrentTime="05:00:00"
| eval CurrentTimepoch=strptime(CurrentTime,"%H:%M:%S")
| eval SLATIME="04:00:00"
| eval SLATIMEepoch=strptime(SLATIME,"%H:%M:%S")
| eval Diff=(SLATIMEepoch-CurrentTimepoch)
| eval Duration=if(Diff<0, "-", "") + tostring(abs(Diff), "duration")
| eval check1=case(Duration>="02:00:00" AND STATUS!=C,"Trigger",1=1,"Dont")
Please help me how to capture specific time i.e. 2 AM and start checking the job status in the query?