DSXchange

I am using DataStage 7.5 on HP UX system. There are hundreds of jobs stored in different projects, I must go to each and every folder to check the job status.

Isn't there any table or file where the list of the statuses for all jobs is stored?

Thanks in advance, Lebu

Each job stores its own status in a separate table. If you need to check everything all the time, script something or build a BASIC routine. The API will allow you to get a list of all projects on the server, then you can iterate through the list of projects and get a list of all jobs in that project. Lastly, you can check the status of each job and report / handle any issues found.

From the command line you would use dsjob. The BASIC API has equivalent functions all starting with DSGet which you can find in the built-in Help index.

Open Director client in Status view. Optionally sort by status. Disable display of Category. Produce a report via Project > Print then choosing Print To File option.

Actually I was thinking about an automated process from server side itself. like getting the list of number of processes in Oracle by v$session

Well why didn't you say so?

Read Craig's post carefully. There's no simple view of "the status of all jobs" on the server. You would need to script something to obtain a list of all jobs then loop through these obtaining the status of each. It's easily doable, but no single view exists.

There is another issue, I donot have the rights to access 'dsadm' from unix.

I see directories like:

/dstage/projects/MikusProj/RT_STATUS*

Is there anyway to extract the job status from these files?

Any DataStage user will do, you don't need to be admin. That or build a Server job.

And no, not like you mean. Use the API.

Or use dsjob command, which itself uses the API.

That's already been mentioned but I assumed the "I do not have the rights" comment meant a scripted approach was not feasible.