Hi All,
Good day.
need help on search query to get below scenario.
as we have few jobs we need data to calculate sla breach if job was not starting on Actual_start_time and also breach if job is not ended in some threshold of time example 30 seconds.
please help on qyery.
JOB_NAME STATUS START_TIME END_TIME DAYS_OF_WEEK ACTUAL_START_TIME RUNTIME count
| PNB-CRDU-USCA-GTRP-EXTRACT-DAILY |
SUCCESS |
2022/11/28 17:00:00 |
2022/11/28 17:26:26 |
mo,tu,we,th,fr |
17:00 |
1586 |
3 |
| PNB-CRDU-USCA-GTRP-EXTRACT-DAILY |
SUCCESS |
2022/11/29 17:00:00 |
2022/11/29 17:29:07 |
mo,tu,we,th,fr |
17:00 |
1747 |
3 |
| PNB-JAWS-TRD-USCA-PORTWARE-EOD-LOAD |
SUCCESS |
2022/11/28 16:30:00 |
2022/11/28 16:51:01 |
mo,tu,we,th,fr |
16:30 |
1261 |
3 |
