Generating a mail after loading 10% of data into target

dsuser7 · Post by **dsuser7** » Sat Nov 29, 2008 2:57 am

Hi,

After loading 10% of data into the target table, can a mail be generated reporting the same while the DataStage parallel job is being running (either through DataStage or through Unix script).
Is there such a possibility in DataStage/unix scripting/through routines?

Any help/suggestions are highly appreciated.

Thanks,
DSUser7.

ArndW · Post by **ArndW** » Sat Nov 29, 2008 5:30 am

If the source is a sequential file, you can have DataStage report statistics to the log file, then write a job or script to examine the log file looking for the percentage figures.

ArndW · Post by **ArndW** » Sat Nov 29, 2008 5:30 am

If the source is a sequential file, you can have DataStage report statistics to the log file, then write a job or script to examine the log file looking for the percentage figures.

dsuser7 · Post by **dsuser7** » Sat Nov 29, 2008 7:01 am

ArndW wrote:If the source is a sequential file, you can have DataStage report statistics to the log file, then write a job or script to examine the log file looking for the percentage figures. ...

Yes, the source is sequential file. Is a log file created for every job by default or do we have to explicitly set any property to make DataStage report statistics to the log file?

Thank you

dsuser7 · Post by **dsuser7** » Sat Nov 29, 2008 7:03 am

ArndW wrote:If the source is a sequential file, you can have DataStage report statistics to the log file, then write a job or script to examine the log file looking for the percentage figures. ...

Yes, the source is sequential file. Is a log file created for every job by default or do we have to explicitly set any property to make DataStage report statistics to the log file?

Thank you

ArndW · Post by **ArndW** » Sat Nov 29, 2008 10:07 am

It is an attribute in the Sequential file stage when you are reading, something like "Display progress" in the options.