Audit Counts

reddy · Post by **reddy** » Sun Aug 13, 2006 9:11 pm

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

loveojha2 · Post by **loveojha2** » Sun Aug 13, 2006 9:20 pm

Do an exact search on ETLStats.
It is very good bunch of tools for the things that you are looking for, posted by our own ETL stat guru Kim Duke.

reddy · Post by **reddy** » Mon Aug 14, 2006 8:50 am

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

kduke · Post by **kduke** » Mon Aug 14, 2006 11:58 am

You have one row per link. A job can have multiple links.