HOW TO: Find Workflows that are not run from a particular date using rep views in PowerCenter
Solution
Following is a sample query to get the workflows that have not been run from a particular date.
select distinct subject_area , workflow_name from rep_task_inst_run where
workflow_name not in (select workflow_name from rep_task_inst_run where
start_time > sysdate - 1 )
order by 1,2
Where, the start_time filter condition can be altered to the required date to filteras per the needs
