How to find the Job Name?

rahulverma · Post by **rahulverma** » Mon Dec 20, 2010 5:23 am

Hello All,

I have a parallel job No2 which is looking for a file as a source.
But the problem here is, the job No1 which creates the particular file is not generating proper file, which is leading to abortion of the job No2.
I am trying to look for the Job No1 among many jobs in repository so as i can check and debug it.
Could you please suggest how do i find Jobname which is creating a file(file name is known to the user)?
Early response is appreciated.
Thanks in advance.

samyamkrishna · Post by **samyamkrishna** » Mon Dec 20, 2010 5:30 am

try this.

go to $DSHOME

run the following commands

1: uv
2: LOGTO <PROJECT NAME>
3: SELECT * FROM DS_JOBS WHERE NAME='JOB NO1';

rahulverma · Post by **rahulverma** » Mon Dec 20, 2010 5:46 am

Thanks for the quick reply.
But my concern is to find out the JobName itself.
I know the file name which is being created by this JOB.
With the help of this file name, i need to find out the Parallel job name.

samyamkrishna · Post by **samyamkrishna** » Mon Dec 20, 2010 5:46 am

viewtopic.php?t=135278&highlight=DS_JOBOBJECTS

DSguru2B · Post by **DSguru2B** » Mon Dec 20, 2010 8:58 am

Search here for Kim's sql that takes in the file name and then searches all the jobs along with their category names, that are using that particular file.

ray.wurlod · Post by **ray.wurlod** » Mon Dec 20, 2010 3:13 pm

Do a "where used" on the table definition. You DO rigorously manage your metadata, don't you?

DSXchange

How to find the Job Name?

How to find the Job Name?

Re: How to find the Job Name?

Re: How to find the Job Name?