Job status information for all jobs on DataStage 7.5

lordlebu · Post by **lordlebu** » Mon May 21, 2012 8:40 am

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

chulett · Post by **chulett** » Mon May 21, 2012 9:31 am

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.

ray.wurlod · Post by **ray.wurlod** » Mon May 21, 2012 5:00 pm

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.

lordlebu · Post by **lordlebu** » Tue May 22, 2012 6:19 am

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

ray.wurlod · Post by **ray.wurlod** » Tue May 22, 2012 4:24 pm

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.

lordlebu · Post by **lordlebu** » Tue May 29, 2012 4:00 am

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?

chulett · Post by **chulett** » Tue May 29, 2012 6:09 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue May 29, 2012 1:10 pm

Or use dsjob command, which itself uses the API.

chulett · Post by **chulett** » Tue May 29, 2012 5:44 pm

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