DSXchange

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.

try this.

go to $DSHOME

run the following commands

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

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.

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.

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