Informatica Query Tables to Pull Workflow Scheduling Information
I have been googling around, searching these forums and various other forums and have not found any good information regarding how to query the informatica tables for scheduling information.
I am looking to query the views/tables from Informatica to be able to pull up a schedule of all the workflows.
Specifically how long the workflow is (not sure if this is possible) and the scheduled time.
My company has a few hundred workflows, and it would be very time consuming to physically go into informatica and pull up the information through the GUI interface individually.
I know there are a few tables/views that i could use including
OPB_SCHEDULER
OPB_SCHEDULE_LOGIC
and the view
REP_WORKFLOWS
None of the columns within these tables/views seem to quite give exactly what I am looking for such as when the workflow will exactly run. When creating a workflow in the scheduler, selecting a "Customized Repeat" I am given the options of
Repeat every # Days
Repeat every # of weeks on Monday, Tuesday etc
Repeat every # of Months running on a specific day of the month
When i look at the tables/views i can pull the start time, but not this specific information (is it run on Mon, Tues etc)
Does anyone have any documentation or insight on how i can query these tables to get the info I need? Or know which table i should be using?
I been bumping around trying to find something for a while now, and im hoping the Oracle forums wont fail me :)
Thanks