Solved

informatica failed tasks version , other repository queries

Posted on 2013-02-07
1
516 Views
Last Modified: 2013-02-25
Hi I need to find informatica failed tasks version , other handy repository queries welcome too
0
Comment
Question by:oleggold
1 Comment
 
LVL 4

Accepted Solution

by:
subratabiswas earned 500 total points
ID: 38865974
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

Featured Post

Are your end users making ugly email signatures?

Have you left it up to your end users to create their own email signatures? Are they forgetting to add the company logo or using garish font colors? Take control and ensure all users have the same email signature.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
In this article, I will show you HOW TO: Perform a Physical to Virtual (P2V) Conversion the easy way from a computer backup (image).
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now