Page 1 of 1
How to access DS_JOBS table? What do I need?
Posted: Mon Jul 12, 2010 1:07 pm
by pavankvk
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?
Posted: Mon Jul 12, 2010 2:00 pm
by chulett
No, you don't - use the 'dsjob' command line API instead.
Posted: Mon Jul 12, 2010 4:13 pm
by ray.wurlod
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.
Posted: Mon Jul 12, 2010 5:04 pm
by chulett
Or just "dsjob -ljobs <Project>".
Posted: Tue Jul 13, 2010 10:44 am
by dsedi
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..)