Hi Gurus,
I have been asked to create a job to generate job statistics report of all the jobs available in the prodcution environment.
My report should have the values as below for all the jobs in production,
Sequencer Name
Job Name
Start Name
End Time
Records read from source (optional)
Records Written
Errors / Warnings
Status (Finished/Finished with warnings/Aborted)
All the above mentioned values should be only taken only for the latest run.
Please help me in achieving it.
Thanks in Advance.
Job Statistics Report
Moderators: chulett, rschirm, roy
There are hidden complexities involved in putting together such information; particularly when you have multiple projects and multi-instance jobs. Mr. Kim Duke has written EtlStats which is available freely and gathers such data as you require.