DSXchange

Posted: **Tue May 16, 2006 5:33 pm**

In DataStage Jobs i need to Capture

JobName
warnings
InRowCount
OutRowCount
Fatals
JobStartTime and
JobEndTime.

For every job i need to capture above mentioned, whether i need to build a routine or Can you suggest me regarding this...

Thanks In Advance

Posted: **Tue May 16, 2006 5:45 pm**

Let me save you a whole lot of grief and cut right to the head of the class - download ETLStats from Kim Duke's DataStage Tips page. Done.

Posted: **Tue May 16, 2006 9:03 pm**

Craig comes through again. Very funny.

Posted: **Tue May 16, 2006 9:05 pm**

I sure hope they integrate stats with DataStage where it belongs and not in MetaStage. You need to make ETL decisions based on these numbers. That is why it is in a job and stored in tables so you can make ETL decisions with it. All this and it is free.

Posted: **Wed May 17, 2006 1:37 am**

Presumably, in Hawk, it's simply a call to the metadata delivery service?

DSXchange

How to capture JobName,warnings etc...

How to capture JobName,warnings etc...