How to capture JobName,warnings etc...

samba · Post by **samba** » 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

chulett · Post by **chulett** » 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.

kduke · Post by **kduke** » Tue May 16, 2006 9:03 pm

Craig comes through again. Very funny.

kduke · Post by **kduke** » 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.

ray.wurlod · Post by **ray.wurlod** » Wed May 17, 2006 1:37 am

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