load job information
Posted: Mon Oct 18, 2010 1:31 pm
Hi All,
I have a situation where i nead to load job information like
Date and Time of job run
Elapsed time
Number of rows returned
Number of rows rejected
Number of rows selected for the target
Number of warnings.
into a database
I have gone through the forum , i got some clues from ETL stats for single job but my concern is to load all the jobs information in particular project .
like for ex: I have 50 jobs in project
I need all 50 jobs information.
Can any one help me with clues. Can we do like that?
Thanks in advance
I have a situation where i nead to load job information like
Date and Time of job run
Elapsed time
Number of rows returned
Number of rows rejected
Number of rows selected for the target
Number of warnings.
into a database
I have gone through the forum , i got some clues from ETL stats for single job but my concern is to load all the jobs information in particular project .
like for ex: I have 50 jobs in project
I need all 50 jobs information.
Can any one help me with clues. Can we do like that?
Thanks in advance