Below script lists the start and finish times of the workflows, also the process length in minutes.
Very useful to watch the performance of Informatica.
Please run it on Informatica Repository Database.
SELECT SUBJECT_AREA, WORKFLOW_NAME, START_TIME, FINISH_TIME, DATEDIFF(mi, START_TIME, FINISH_TIME) AS DURATION_MINUTE FROM ( SELECT SUBJECT_AREA, WORKFLOW_NAME, WORKFLOW_RUN_ID, MIN(ACTUAL_START) AS START_TIME , MAX(SESSION_TIMESTAMP) AS FINISH_TIME FROM dbo.REP_SESS_LOG (NOLOCK) WHERE ACTUAL_START BETWEEN '20110701' AND '20110702' /*FILTER BY SUBJECT_AREA*/ --AND SUBJECT_AREA = 'INTERFACE' /*FILTER BY WORKFLOW_NAME*/ --AND WORKFLOW_NAME = 'wf_CORE_BASI_EOD' GROUP BY SUBJECT_AREA, WORKFLOW_NAME, WORKFLOW_RUN_ID ) SUB_TABLE WHERE DATEDIFF(mi, START_TIME, FINISH_TIME) > 0 ORDER BY 1, 2, 3
