Worklet Task Run Details
Displays the run statistics of all tasks in a worklet by repository by folder.
Click on the text to copy the query report to your clipboard.
select "WORKFLOW_NAME",
"END_TIME",
"RUN_ERR_CODE",
"REPOSITORY_NAME",
"RUN_ERR_MSG",
"INSTANCE_NAME",
"TASK_TYPE_NAME",
"SUBJECT_AREA",
"TASK_NAME",
case when ("RUN_STATUS_CODE" <= 9) then (case when ("RUN_STATUS_CODE" = 1) then ('Succeeded') else (case when ("RUN_STATUS_CODE" = 2) then ('Disabled') else (case when ("RUN_STATUS_CODE" = 3) then ('Failed') else (case when ("RUN_STATUS_CODE" = 4) then ('Stopped') else (case when ("RUN_STATUS_CODE" = 5) then ('Aborted') else (case when ("RUN_STATUS_CODE" = 6) then ('Running') else (case when ("RUN_STATUS_CODE" = 7) then ('Suspending') else (case when ("RUN_STATUS_CODE" = 8) then ('Suspended') else (case when ("RUN_STATUS_CODE" = 9) then ('Stopping') else ('') end) end) end) end) end) end) end) end) end) else (case when ("RUN_STATUS_CODE" = 10) then ('Aborting') else (case when ("RUN_STATUS_CODE" = 11) then ('Waiting') else (case when ("RUN_STATUS_CODE" = 12) then ('Scheduled') else (case when ("RUN_STATUS_CODE" = 13) then ('UnScheduled') else (case when ("RUN_STATUS_CODE" = 14) then ('Unknown') else (case when ("RUN_STATUS_CODE" = 15) then ('Terminated') else ('') end) end) end) end) end) end) end as "Calc_RUN_STATUS_CODE",
"START_TIME"
from (SELECT DISTINCT WORKLET_REPOSIT_INFO.REPOSITORY_NAME, ALL_WORKLETS.SUBJECT_AREA, ALL_WORKLETS.TASK_NAME, WORKLET_RUN.WORKFLOW_NAME, WORKLET_TASK_INST_RUN.TASK_TYPE_NAME, WORKLET_TASK_INST_RUN.INSTANCE_NAME, WORKLET_TASK_INST_RUN.START_TIME as START_TIME, WORKLET_TASK_INST_RUN.END_TIME as END_TIME, WORKLET_TASK_INST_RUN.RUN_STATUS_CODE as RUN_STATUS_CODE, WORKLET_TASK_INST_RUN.RUN_ERR_CODE, WORKLET_TASK_INST_RUN.RUN_ERR_MSG as RUN_ERR_MSG FROM REP_ALL_TASKS ALL_WORKLETS, REP_TASK_INST_RUN WORKLET_RUN, REP_REPOSIT_INFO WORKLET_REPOSIT_INFO, REP_TASK_INST_RUN WORKLET_TASK_INST_RUN WHERE (ALL_WORKLETS.TASK_ID = WORKLET_RUN.TASK_ID AND ALL_WORKLETS.VERSION_NUMBER = WORKLET_RUN.TASK_VERSION_NUMBER AND ALL_WORKLETS.TASK_ID <> WORKLET_REPOSIT_INFO.REPOSITORY_ID AND ALL_WORKLETS.TASK_TYPE = 70 AND WORKLET_RUN.WORKFLOW_ID = WORKLET_TASK_INST_RUN.WORKFLOW_ID AND WORKLET_RUN.WORKFLOW_RUN_ID = WORKLET_TASK_INST_RUN.WORKFLOW_RUN_ID AND WORKLET_RUN.WORKLET_RUN_ID = WORKLET_TASK_INST_RUN.WORKLET_RUN_ID )) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and "TASK_NAME" in ('<Worklet_Name>') and "START_TIME" between DATE '<Start_Date>' and DATE '<End_Date>'
order by "REPOSITORY_NAME", "SUBJECT_AREA"