Generating Job auditing information

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
mydsworld
Participant
Posts: 321
Joined: Thu Sep 07, 2006 3:55 am

Generating Job auditing information

Post by mydsworld »

Hi,
I am trying to build up a job that will generate auditing information (like start date,rowcount etc) of other jobs (using jobname as parameter).Whats the best way to do that in DS8. Thanks
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Download ETLStats from Kim Duke's website, of course. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Please delete your other duplicate post, before anyone else responds to it.
As Craig advised, you can get Kim's EtlStats or you can weave your own routine that can take in a list of all job names and come up with stats.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
vinodn
Charter Member
Charter Member
Posts: 93
Joined: Tue Dec 13, 2005 11:00 am

Post by vinodn »

How to to take all job names in a project and how that routine works !, could you ls expalin me, how to find all Jobnames and statistics in the project , what are the commands we have to use....
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Get ETLStats anyway, and review the code. All your answers are there.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply