Hello Guys,
We have almost 300 jobs which was in 10 job sequences.I have to get jobname,start date,start time,end time,elapsed time,input count,output counts,jo status data from all these jobs and load data into audit summary table.
Can you please help me how to design to get audit counts at runtime at job sequence level.
I will appreciate your help.
Thanks in advance
Reddy
Audit Counts
Moderators: chulett, rschirm, roy
Thanks for reply.I went through Kim's etlstats but when i used DSJobReportDb for getting rowcounts i am getting mulitple rows.
suppose if i have
source---IN---->transf-----OUT--->target
i need job name,IN Count,Out Count,elapsed Date and Time in one row.
Can you please help me on how to get a single row.
Thanks in advance
Reddy
suppose if i have
source---IN---->transf-----OUT--->target
i need job name,IN Count,Out Count,elapsed Date and Time in one row.
Can you please help me on how to get a single row.
Thanks in advance
Reddy