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?
How to access DS_JOBS table? What do I need?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
However, if you feel that you really must query the DS_JOBS table you can use the Administrator client's Command window.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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..)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?
Accept that some days you're the pigeon and some days you're the statue.