I need to copy the following stats of each ETL process into a DB table:
Code: Select all
No. of records read from Src
No. of records failed to read from Src
No. of records to tgt
Records rejected by Tgt
Start_Time
End_Time
Kumar
Moderators: chulett, rschirm, roy
Code: Select all
No. of records read from Src
No. of records failed to read from Src
No. of records to tgt
Records rejected by Tgt
Start_Time
End_Time
Your understanding is wrong. Completely free, thanks to the generosity of Kim Duke.vskr72 wrote:I understand that that ETLStats is not free.
Yes, use the DSGet* functions such as DSGetJobInfo() and DSGetLinkInfo() for that. There are dsjob equivalents for all of those functions as well, so you could do this either from your own job control code or shell scripts.vskr72 also wrote:Is it really possible to get these details from the job itself?