Informatica Query Tables for Workflow Schedules (SCHEDULER, WORKFLOWS)

[rodneyc8063]

I have been googling around, searching these forums and various other forums and havent been able to piece anything conclusive together.

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 informtica 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?

Thanks

 

[blom0344]

If memory serves wel than the INFA schedule data was pseudo-encrypted. There is a seemingly 'random' integer value that stores the information about the schedule. Do not expect to find a table that stores this data like:

| Day | Time |

Monday 11.00

Ties Blom