Workflow Run Details

Displays the run statistics of all workflows by repository by folder. This is a primary report in an analytic workflow.


Click on the text to copy the query report to your clipboard.


select "USER_NAME",
"START_TIME",
"SERVER_NAME",
"LOG_FILE",
"REPOSITORY_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",
"RUN_ERR_MSG",
case when ("RUN_TYPE" = 1) then ('Normal') else (case when ("RUN_TYPE" = 2) then ('Recovery') else ('') end) end as "Calc_RUN_TYPE",
"SUBJECT_AREA",
"END_TIME",
"RUN_ERR_CODE",
"WORKFLOW_NAME"
from (SELECT DISTINCT WORKFLOW_REPOSIT_INFO.REPOSITORY_NAME, ALL_WORKFLOWS.SUBJECT_AREA, ALL_WORKFLOWS.WORKFLOW_NAME, WORKFLOW_RUN.USER_NAME, WORKFLOW_RUN.SERVER_NAME,  WORKFLOW_RUN.START_TIME AS START_TIME ,WORKFLOW_RUN.END_TIME as END_TIME , WORKFLOW_RUN.RUN_STATUS_CODE as RUN_STATUS_CODE,  WORKFLOW_RUN.RUN_ERR_CODE, WORKFLOW_RUN.RUN_ERR_MSG as RUN_ERR_MSG, WORKFLOW_RUN.LOG_FILE as LOG_FILE, WORKFLOW_RUN.RUN_TYPE as RUN_TYPE FROM  REP_REPOSIT_INFO WORKFLOW_REPOSIT_INFO,  REP_WORKFLOWS ALL_WORKFLOWS,  REP_WFLOW_RUN WORKFLOW_RUN  WHERE  (ALL_WORKFLOWS.WORKFLOW_ID <> WORKFLOW_REPOSIT_INFO.REPOSITORY_ID AND  ALL_WORKFLOWS.WORKFLOW_ID = WORKFLOW_RUN.WORKFLOW_ID AND  ALL_WORKFLOWS.WORKFLOW_VERSION_NUMBER = WORKFLOW_RUN.VERSION_NUMBER )) "query"
where "SUBJECT_AREA" in ('<Folder_Name>') and "WORKFLOW_NAME" in ('<Workflow_Name>') and "START_TIME" between DATE '<Start_Date>' and DATE '<End_Date>'
order by "REPOSITORY_NAME", "SUBJECT_AREA"

Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
*
*