Page 1 of 1
Trace back RT_STATUS files to DS jobs
Posted: Thu Nov 04, 2004 6:01 pm
by cbres00
Is there a way to trace back RT_xxx files to their Designer jobs?
Regards,
Cathy
Posted: Thu Nov 04, 2004 7:22 pm
by ray.wurlod
Code: Select all
SELECT NAME FROM DS_JOBS WHERE JOBNO = 'xxx';
Every DataStage job has a unique number, and the mapping is in the DS_JOBS table.
Beware that the SQL is case sensitive.
Posted: Thu Nov 04, 2004 7:32 pm
by cbres00
Beautiful....but one question: where do I execute this?
Cathy
Posted: Thu Nov 04, 2004 8:06 pm
by chulett
Easiest answer... from the Administrator.
Posted: Thu Nov 04, 2004 8:16 pm
by ray.wurlod
More complete answer: from the Administrator client Command window for the project.
Alternative answer: from the TCL prompt on the server, which you need to get to via telnet then invoke when attached to your project directory (and having run the $DSHOME/dsenv script) using the uv or uvsh command.
Posted: Thu Nov 04, 2004 8:18 pm
by chulett
ray.wurlod wrote:More complete answer: from the Administrator client Command window for the project.
Posted: Fri Nov 05, 2004 12:23 am
by cbres00
Beauty!
Thanks!
Cathy