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
How to get the information regarding job
Moderators: chulett, rschirm, roy
Re: How to get the information regarding job
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.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Download ETLstats from Kim Duke's website - it does all that for you. Never re-invent the wheel unnecessarily.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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.
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.
Mamu Kim