Informatica Workflow Execution Dashboard Metadata Query:

Folder Name, Workflow Name, Last Start Time, Time since Last Execution

Many times because of various reasons Informatica scheduled workflows come off schedule. In an environment where continuous monitoring is not available and the operations or development team wants to keep a track of the ETL jobs on a need by basis, the below query can be used which may be set up in your BI tool or run on ad-hoc basis.

Informatica Repository used is SQL Sever. Modify the query based on the Repository Database.

select SUBJECT_AREA, WORKFLOW_NAME, LAST_START_TIME, CONVERT(VARCHAR(12), DATEADD(MS, DATEDIFF(MS, last_start_time, getdate()), 0), 114) time_since_last_execution
from (
select SUBJECT_AREA, WORKFLOW_NAME, max(start_time) last_start_time from [dbo].[REP_WFLOW_RUN]
where START_TIME between DATEADD(HOUR, -24, GETDATE()) and getdate()
group by SUBJECT_AREA, WORKFLOW_NAME) a
order by LAST_START_TIME desc