To locate Hash file or any job directly from Administrator

[DEVESHASTHANA]

Hi,
Is there any command ,or way through which we can locate that job exist in which project folder catagory,


regards,

Devesh

[davidnemirovsky]

Not sure if this is the way you'd like to do it but if you're looking for a job you can't find then open Director and in the 'View' menu at the top click 'Show Categories' to remove the tick. This will show you a list of all jobs and which category they belong to.

Be warned! It can take a while to refresh. Categories were introduced early on in Datastage as refreshing an entire project without categories with many jobs can take a long time (my current project took about 5 minutes to refresh).

A painful but easy method to find your job.

[kduke]

Here is SQL to find a hash file. I assume you can modify to find a job.

Code: Select all

select 
   DS_JOBS.NAME AS JOB_NAME FMT '35L',
   DS_JOBS.CATEGORY,
   DS_JOBOBJECTS.NAME AS LINK_NAME FMT '35L'
from 
   DS_JOBOBJECTS, 
   DS_JOBS
where 
   DS_JOBOBJECTS.OLETYPE in ('CHashedOutput','CHashedInput') 
   and DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO
   and EVAL DS_JOBOBJECTS."@RECORD<6>" = 'DealOrderDimHash'
group by 
   JOB_NAME,
   CATEGORY,
   LINK_NAME
;

[chulett]

Well, here's an easy and painless way.

From the Projects / Command tab of the Administrator:

Code: Select all

SELECT CATEGORY FROM DS_JOBS WHERE NAME = 'JobName';

[DEVESHASTHANA]

THANKS TO U ALL,

Regards,

Devesh

[davidnemirovsky]

OK, Craig wins