Trace back RT_STATUS files to DS jobs

cbres00 · Post by **cbres00** » Thu Nov 04, 2004 6:01 pm

Is there a way to trace back RT_xxx files to their Designer jobs?

Regards,
Cathy

ray.wurlod · Post by **ray.wurlod** » Thu Nov 04, 2004 7:22 pm

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.

cbres00 · Post by **cbres00** » Thu Nov 04, 2004 7:32 pm

Beautiful....but one question: where do I execute this?

Cathy

chulett · Post by **chulett** » Thu Nov 04, 2004 8:06 pm

Easiest answer... from the Administrator.

ray.wurlod · Post by **ray.wurlod** » Thu Nov 04, 2004 8:16 pm

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.

chulett · Post by **chulett** » Thu Nov 04, 2004 8:18 pm

ray.wurlod wrote:More complete answer: from the Administrator client Command window for the project.

cbres00 · Post by **cbres00** » Fri Nov 05, 2004 12:23 am

Beauty!

Thanks!
Cathy