How to get the information regarding job

itsgops · Post by **itsgops** » Tue Apr 21, 2009 2:10 am

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

Pagadrai · Post by **Pagadrai** » Tue Apr 21, 2009 2:30 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Apr 21, 2009 3:10 am

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

mekrreddy · Post by **mekrreddy** » Tue Apr 21, 2009 7:51 am

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

kduke · Post by **kduke** » Tue Apr 21, 2009 8:29 am

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.

DSXchange

How to get the information regarding job

How to get the information regarding job

Re: How to get the information regarding job