Hi all,
I need to load job information like source filename and pathname,Job name, Job status, job start and end time, Number of records processed and number of success records and failure records into another table. Is there a way we can can retrieve all the information other than scripting? Or else can anyone post the script to do this operation . Thanks
regards
Need to load Job information into a table
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 57
- Joined: Tue Jun 30, 2009 9:38 am
EtlStats will give you the row counts. Source and target tables maybe a lot more difficult. There are jobs in EtlStats to extract metadata from PX jobs for custom stages. Most PX jobs use custom stages underneath the covers. These columns have one field which stores the property name and another which stores the property value. Each stage type has unique names. Some have TABLENAME and other use TABLE. You need to extract these and look at them. If you use User Defined SQL then you need to parse it to get the table names. There are other post which describe these jobs and how to use them. Do a search.
Mamu Kim