Informatica help

Informatica help and metadata report query

Workflow Task Run Details

Workflow Task Run Details

Displays the run statistics of all worklets by repository by folder.


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


select "START_TIME",
"RUN_ERR_CODE",
"RUN_ERR_MSG",
"END_TIME",
"TASK_TYPE_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",
"INSTANCE_NAME",
"WORKFLOW_NAME",
"SUBJECT_AREA",
"REPOSITORY_NAME"
from (SELECT  DISTINCT WORKFLOW_REPOSIT_INFO.REPOSITORY_NAME,  ALL_WORKFLOWS.SUBJECT_AREA,  ALL_WORKFLOWS.WORKFLOW_NAME,  WORKFLOW_TASK_INST_RUN.TASK_TYPE_NAME,  WORKFLOW_TASK_INST_RUN.INSTANCE_NAME,  WORKFLOW_TASK_INST_RUN.START_TIME as START_TIME,  to_char(WORKFLOW_TASK_INST_RUN.END_TIME,'mm/dd/yy HH:MI:SS AM') as END_TIME, WORKFLOW_TASK_INST_RUN.RUN_STATUS_CODE  AS RUN_STATUS_CODE,    WORKFLOW_TASK_INST_RUN.RUN_ERR_CODE,  WORKFLOW_TASK_INST_RUN.RUN_ERR_MSG As RUN_ERR_MSG FROM  REP_WFLOW_RUN WORKFLOW_RUN,  REP_TASK_INST_RUN WORKFLOW_TASK_INST_RUN,  REP_WORKFLOWS ALL_WORKFLOWS,  REP_REPOSIT_INFO WORKFLOW_REPOSIT_INFO  WHERE  (WORKFLOW_RUN.WORKFLOW_ID = WORKFLOW_TASK_INST_RUN.WORKFLOW_ID AND  WORKFLOW_RUN.WORKFLOW_RUN_ID = WORKFLOW_TASK_INST_RUN.WORKFLOW_RUN_ID AND  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 Reply

Your email address will not be published.Email address is required.

Sponsored Content


Canon EOS 5D Mark IV Full Frame Digital SLR Camera Body


Canon EF 24-70mm f/2.8L II USM Standard Zoom Lens

GoPro HERO5 Black

Canon EF 100-400mm f/4.5-5.6L IS II USM Lens

Firefield FF16001 NVRS 3x 42mm Gen 1 Night Vision Riflescope, Black

Visitors


Quantcast