How to access DS_JOBS table? What do I need?

pavankvk · Post by **pavankvk** » Mon Jul 12, 2010 1:07 pm

Hi,

We are on 8.1 Datastage, I need to access DS_JOBS table to query a list of jobs in the project. How can I access DS_JOBS table?

chulett · Post by **chulett** » Mon Jul 12, 2010 2:00 pm

No, you don't - use the 'dsjob' command line API instead.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 12, 2010 4:13 pm

There's no guarantee that what you want is in the DS_JOBS table - it may be in a table in the unified metadata repository (the XMETA database).

However, if you feel that you really must query the DS_JOBS table you can use the Administrator client's Command window.

chulett · Post by **chulett** » Mon Jul 12, 2010 5:04 pm

Or just "dsjob -ljobs <Project>".

dsedi · Post by **dsedi** » Tue Jul 13, 2010 10:44 am

pavankvk wrote:Hi,

We are on 8.1 Datastage, I need to access DS_JOBS table to query a list of jobs in the project. How can I access DS_JOBS table?

using SELECT NAME, CATEGORY FROM DS_JOBS on Datastage Admin "Command interface" window..Or by using a Universe Stage in a simple Server job(if you want the job list with specific criteria and want to put it into a file or something..)