DSXchange

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

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.

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

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