Page 1 of 1
JOB Log info recording into tables
Posted: Fri Jan 10, 2003 7:31 am
by rasi
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
Posted: Fri Jan 10, 2003 8:01 am
by sankar18
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
Posted: Fri Jan 10, 2003 1:55 pm
by ray.wurlod
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