Page 1 of 1

How to find where the job is ?

Posted: Wed Apr 18, 2007 9:47 pm
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

Re: How to find where the job is ?

Posted: Wed Apr 18, 2007 9:58 pm
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

Posted: Wed Apr 18, 2007 10:48 pm
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.

Posted: Thu Apr 19, 2007 12:18 am
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

Posted: Thu Apr 19, 2007 4:55 am
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?