How To Find Start And End Time Of Any Behaviour Detection(Scenario Related) Task Of Batch (Doc ID 2852366.1)

Last updated on MARCH 05, 2022

Applies to:

Goal

How to find Start and end time of any behavior detection(Scenario related) task of batch. Please provide the tables. As client observed below query not listing behavior detection(Scenario related) tasks

SELECT
V_BATCH_RUN_ID,
V_TASK_ID,to_number(SUBSTR(v_task_id,5,7)) Task_order,
TO_CHAR(Min(TIMESTAMP),'DD-MON-YYYY HH24:MI:SS') Start_time,
TO_CHAR(MAX(TIMESTAMP),'DD-MON-YYYY HH24:MI:SS') End_time,
round(((nvl(MAX(TIMESTAMP),sysdate)-Min(TIMESTAMP))*24*60)) Elapsed_Time_Mins,
V_TASK_STATUS
FROM PRO_OFSAACONF.BATCH_MONITOR
WHERE V_BATCH_RUN_ID like '%Batch run id%' and V_TASK_ID!='NOTASKID'
GROUP BY V_BATCH_RUN_ID,V_TASK_ID,V_TASK_STATUS
ORDER BY task_order asc;

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.