How to find where the job is ?

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
xinhuang66
Participant
Posts: 161
Joined: Wed Aug 02, 2006 4:30 am

How to find where the job is ?

Post by xinhuang66 »

I have a big datastage job, it has a lot of category, sub-category, and son.

Somebody gave me a job name and ask me have a look.

I just couldn't locate it, somebody tell me how to search it ??

Thanks
saugat_1982
Participant
Posts: 29
Joined: Mon Nov 20, 2006 7:17 am
Location: Melbourne

Re: How to find where the job is ?

Post by saugat_1982 »

xinhuang66 wrote:I have a big datastage job, it has a lot of category, sub-category, and son.

Somebody gave me a job name and ask me have a look.

I just couldn't locate it, somebody tell me how to search it ??

Thanks
Hi

You have to ask for Server and Project name to locate a job
Saugat Dey
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Director client has a search facility.

It also has the ability to switch off display of Category, so that you can get all jobs in the project in a single listing. Look under the View menu.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
boppanakrishna
Participant
Posts: 106
Joined: Thu Jul 27, 2006 10:05 pm
Location: Mumbai

Post by boppanakrishna »

hi
You can query from the Administrator command line to get the exct location of teh Jobname

Query: SELECT NAME,CATEGORY FROM DS_JOBS WHERE JOB_NAME=' URJOBNAME'

RESULT: THIS DISPLAYS ALL THE SUBCATEGORY'S ALSO
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

JOB_NAME is not a column in the DS_JOBS table.
Use NAME as the column name in the WHERE clause.
Remember to use a trailing semi-colon on all DataStage/SQL statements.

Which of the given solutions was your resolution?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply