Page 1 of 1
How to find the last 10runs time of a job
Posted: Tue Aug 08, 2006 4:32 am
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
Posted: Tue Aug 08, 2006 7:00 am
by kduke
If you have not cleared the log then there is a job within EtlStats which will retrieve this from the log file.
Posted: Tue Aug 08, 2006 7:07 am
by kduke
Not sure it works with PX jobs. Never tried it.
Posted: Tue Aug 08, 2006 10:04 am
by clickart
Can you give the full path of the Etlstats folder?
Posted: Tue Aug 08, 2006 5:54 pm
by kduke
You have to download it from one of the 2 links below my signature.
Re: How to find the last 10runs time of a job
Posted: Wed Aug 09, 2006 1:07 am
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....