Job Audit Logs
Posted: Wed Mar 22, 2006 11:03 am
Hi Datastage gurus,
I have a question on designing of Job audit logs.
I have 8 jobs running in production but now i have a requirement like this :
I have to create a Oracle Audit_log table with columns source_tablename,source_count,target_tablename,target_count,run_date.
I created a Audit_log table like the above requirement.
All jobs using ODBC Table as a source and Oracle Table as a target.
Can you light on me how to design the jobs to load audit_log table after the original job ran ......
Thanks in advance.
Reddy
I have a question on designing of Job audit logs.
I have 8 jobs running in production but now i have a requirement like this :
I have to create a Oracle Audit_log table with columns source_tablename,source_count,target_tablename,target_count,run_date.
I created a Audit_log table like the above requirement.
All jobs using ODBC Table as a source and Oracle Table as a target.
Can you light on me how to design the jobs to load audit_log table after the original job ran ......
Thanks in advance.
Reddy