informatica failed tasks version , other repository queries

Hi I need to find informatica failed tasks version , other handy repository queries welcome too
LVL 21
oleggoldAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
subratabiswasConnect With a Mentor Commented:
Hi,

Can you please clarify on the question? If you want to find the relevant information from the Informatica repository by using SQL statements, then please look at the table OPB_TASK_INST_RUN. Various values of RUN_STATUS_CODE in that table are as follows:

1 = Suceeded
2 = Disabled
3 = Failed
4 = Stopped
5 = Aborted
6 = Running
7 = Suspending
8 = Suspended
9 = Stopping
10 = Aborting
11 = Waiting
12 = Scheduled
13 = Unscheduled
14 = Unknown
15 = Terminated


The table contains version number also.

If you wanted something else, please let me know.
0
All Courses

From novice to tech pro — start learning today.