DSXchange

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users




Message



DataStage=20
World,
 
Here =
are our=20
details:
DataStage:=20
v6.1
OS: =
AIX=20
5.2
Staging Repository:=20
Oracle v9.2  (We use ORAOCI9 Stages)
 
My =
team wants to=20
start collect some jobs details about our ETL jobs and store them in=20
an DataStage Audit Table within our persistent staging area (In=20
Oracle)
For a =
job we want to=20
collect the following details:
1. Job =
Name=20
(Done)
2. Job =
Target Table=20
Name(s) !!!!!!
3. Job =
Start Time=20
(Done)
4. Job =
End Time=20
(Done)
 
How, =
within a job=20
(not a controller) or a routine, could I capture a target oracle table=20
name(s).... so that we can pass this information to the audit=20
table.  We know how to capture this data from job logs via a job=20
controller, but we are trying to embed this functionality within =
individual=20
jobs.
 
Please =
let me know=20
if I'm crazy.... or if you all need more details.
 
Cheers,
 
Tim =
Walsh