Finding a job

videsh77 · Post by **videsh77** » Wed Dec 22, 2004 10:24 am

What command to be given in DS Admin console to find a job?

Also, can anyone suggest me a place where I will find a comprehensive list of commands to be given at Command interface with DS Administrator?

ArndW · Post by **ArndW** » Wed Dec 22, 2004 10:31 am

Hello Videsh,

The Administrator is not the right place to look for jobs, that is best done in any of the 3 other programs. The command line calls are not needed for normal day-to-day DataStage work, therefore they are not documented in detail in the DataStage product. The underlying engine is almost identical to IBM's "UniVerse" product; if you go to IBM's website and search for universe documentation you will find several PDF documents detailing more information about what you can do from the command line than you can shake a stick at.

http://www-306.ibm.com/software/data/u2 ... y/952univ/

and I'd look at the http://www-306.ibm.com/software/data/u2 ... 04-952.pdf (the user guide).

ArndW · Post by **ArndW** » Wed Dec 22, 2004 10:33 am

I just noticed that I linked to the 9.5.2 documentation, the 10.x is on IBM's site as well.

videsh77 · Post by **videsh77** » Wed Dec 22, 2004 12:19 pm

ArnW, Thanks for the links.

But it didnt solve my problem. I am having many jobs in my project, which are classified under different categories.

I need to know, given a command & a jobname it will tell me which category that job resides.

kcbland · Post by **kcbland** » Wed Dec 22, 2004 12:31 pm

videsh77 wrote:What command to be given in DS Admin console to find a job??

The only command you can give is a DS Engine command, and the DS Engine is a code branch of IBM's Universe product, therefore Arnd has pointed you in the right direction. Look here for commentary:
viewtopic.php?t=87916&highlight=dsjobs+category

videsh77 wrote: Also, can anyone suggest me a place where I will find a comprehensive list of commands to be given at Command interface with DS Administrator?

Arnd has done so.

lebos · Post by **lebos** » Wed Dec 22, 2004 1:00 pm

In DataStage Director, under view in the menu, click on "Show All" and/or unclick on "Show Categories". One of these combinations will dispaly all jobs in the project.

Larry

chulett · Post by **chulett** » Wed Dec 22, 2004 1:26 pm

Check this post for the syntax you are looking for.

videsh77 · Post by **videsh77** » Fri Dec 24, 2004 4:04 am

Thanks Craig & ArnW

SELECT CATEGORY FROM DS_JOBS WHERE NAME = 'JobName';

It will give you the category in which your job resides.

DSXchange

Finding a job

Finding a job

Re: Finding a job