DSXchange

Hi,

I want to get the information such as how many records are passed on each and every links, job status, elapsed time and job name. And all the informations has to be loaded into the target table...

Let me know any other possiblity way to load this informations to the target table.

Give me some idea regarding this...

________________
Thnaks in Advance
ItsGops

Hi,
There are lot of posts about obtaining job information.
Do a search on DSjob commands.

Also, read up the manuals for DSjob commands.
You will get all the details required.

Download ETLstats from Kim Duke's website - it does all that for you. Never re-invent the wheel unnecessarily.

ETL stats in Kim Duke site is for server jobs...

They are server jobs but they can gather information on PX jobs. There is a version for PX. There are several posts on getting more detail on PX jobs like row counts at the partition level.

These jobs are just examples on how to do this and other ETL tricks. You are expected to modify these jobs to meet your needs. Vincent did the modification to aggregate the partitions up to the link level for PX jobs. This is a simple change. To get this detail back is also an easy change.