JOB ID In datastage

ntr · Post by **ntr** » Thu Sep 20, 2012 12:50 pm

Hi ,

Please help me where i need to check Job id ..

Regards,
ntr

PaulVL · Post by **PaulVL** » Thu Sep 20, 2012 12:58 pm

EASY way to find it is to open director, open the job, double click on any log entry in the job, and read the field that says JOB ID.

bhasds · Post by **bhasds** » Thu Sep 20, 2012 1:01 pm

or

execute the command

Code: Select all

LIST DS_JOBS WITH @ID=job_name

in administrator command prompt

ntr · Post by **ntr** » Thu Sep 20, 2012 1:07 pm

Small confusion Please help me JOB ID and JOB NO Same ?

bhasds · Post by **bhasds** » Thu Sep 20, 2012 1:20 pm

Hi ntr,

If you are searching with the job number, then you can search with the job number in the DS_JOBS table-

Code: Select all

SELECT NAME FROM DS_JOBS WHERE JOBNO = 'job_number';

The above query can be executed in administrator command prompt.

ntr · Post by **ntr** » Thu Sep 20, 2012 1:25 pm

Thanks for your repaly...

chulett · Post by **chulett** » Thu Sep 20, 2012 2:07 pm

ntr wrote:Small confusion Please help me JOB ID and JOB NO Same ?

No, they are not. JOB ID is something I've never had an occassion to use but from what I remember is a user-defined ID that you manually assign to a particular job. Then dsjob can start the job by name or ID.

This is also different from the @ID mentioned earlier...

ray.wurlod · Post by **ray.wurlod** » Thu Sep 20, 2012 3:25 pm

The best way to think of job ID is as an "alias" for the real job name. As Craig notes, there's no requirement at all to use it, but it's sometimes useful where the real job names are long/unwieldy.