Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
-
Madhu1981
- Participant
- Posts: 69
- Joined: Wed Feb 22, 2006 7:49 am
Post
by Madhu1981 »
Hi All,
I have a scenario like to get the last 10 runs timestamp of a perticular job.
Is there any datastage repository table which will give this information.
thanks in advance
-
kduke
- Charter Member
- Posts: 5227
- Joined: Thu May 29, 2003 9:47 am
- Location: Dallas, TX
-
Contact:
Post
by kduke »
If you have not cleared the log then there is a job within EtlStats which will retrieve this from the log file.
Mamu Kim
-
kduke
- Charter Member
- Posts: 5227
- Joined: Thu May 29, 2003 9:47 am
- Location: Dallas, TX
-
Contact:
Post
by kduke »
Not sure it works with PX jobs. Never tried it.
Mamu Kim
-
clickart
- Premium Member
- Posts: 15
- Joined: Tue Oct 18, 2005 10:14 pm
- Location: Schaumburg, IL
Post
by clickart »
Can you give the full path of the Etlstats folder?
-
kduke
- Charter Member
- Posts: 5227
- Joined: Thu May 29, 2003 9:47 am
- Location: Dallas, TX
-
Contact:
Post
by kduke »
You have to download it from one of the 2 links below my signature.
Mamu Kim
-
madhukar
- Participant
- Posts: 86
- Joined: Fri May 20, 2005 4:05 pm
Post
by madhukar »
u can define a temp table and load statistics of each run into the table.
Query "temp" table for hw many runs u want....