JOB Log info recording into tables

rasi · Post by **rasi** » Fri Jan 10, 2003 7:31 am

Hi all,

I want to insert the log entries like how many rows processed, status, time taken into database table while running the job. Which is the best way to get those information.

Thanks
Rasi

sankar18 · Post by **sankar18** » Fri Jan 10, 2003 8:01 am

Hi,

you can do it, In Director, Monitor is there, choose save option the value will be stored, you should run another job, watch the file, from the you take the information, update the information into file.

with regards,
T Sankar

Edited by - sankar18 on 01/10/2003 08:16:26

ray.wurlod · Post by **ray.wurlod** » Fri Jan 10, 2003 1:55 pm

DSGetLinkInfo() returns the number of rows processed along a link.
Date() and Time() functions return the date and time.
Alternately, message in the log file that report the completion of an active stage include the number of rows processed on each link connected to that active stage. DSGetLogEvent() can retrieve this information.
You can create an after-stage routine to report these where you will.

Edited by - ray.wurlod on 01/10/2003 13:56:31