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
JOB Log info recording into tables
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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