_______________________________________________
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
DataStage: Target Table Names
DataStage: Target Table Names
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.