How to find the last 10runs time of a job

Madhu1981 · Post by **Madhu1981** » Tue Aug 08, 2006 4:32 am

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 · Post by **kduke** » Tue Aug 08, 2006 7:00 am

If you have not cleared the log then there is a job within EtlStats which will retrieve this from the log file.

kduke · Post by **kduke** » Tue Aug 08, 2006 7:07 am

Not sure it works with PX jobs. Never tried it.

clickart · Post by **clickart** » Tue Aug 08, 2006 10:04 am

Can you give the full path of the Etlstats folder?

kduke · Post by **kduke** » Tue Aug 08, 2006 5:54 pm

You have to download it from one of the 2 links below my signature.

madhukar · Post by **madhukar** » Wed Aug 09, 2006 1:07 am

u can define a temp table and load statistics of each run into the table.
Query "temp" table for hw many runs u want....

DSXchange

How to find the last 10runs time of a job

How to find the last 10runs time of a job

Re: How to find the last 10runs time of a job