DSXchange

Hi All,

trying to retrieve the Job Status through a Universe Stage. As it is not stored in the DS_JOB ther must be another place... But hey... Where's that ?!

William

PS documentation-suggestions on DS_JOBS and alike are also welcome...

The internal hashed fiiles / tables such as DS_JOBS and the RT_STATUSnnn file are not documented by IBM so there will be little help forthcoming there, albeit a search of DSXchange will give you a lot information.

The correct way of getting the status is to use the DSGetJobInfo() routine instead of looking at the status file contents.

The correct way of getting the status is to use the DSGetJobInfo() routine instead of looking at the status file contents

Agree... Problem is I want to loop through the list of jobs that didn't finish correctly (And then take all the warnings from the log and put those in a seperate HTML-file... ) Got that last part up and running for any named job... Just need to create me a list of all 'jobs in error' through a select like:

SELECT NAME
FROM DS_JOBS
WHERE STATUS <> 'Ok'

or alike....

You can't do that. You need to loop through all jobs and then check their status individually.

I was afraid so...

How bout a DS_JOBS query that recursively finds me all the underlying jobnames of a named sequence (which I do have)?

Pretty sure Kim Duke has posted that here somewhere...

There's also the dssearch command but that relies on the metadata in the Sequence job, specifically the information on the Dependencies tab that isn't always 100%.

There is a post on how to get the job names out of a sequence. There is no post or job to do this recursively.

Worked my way around it by only checking a given Sequence. This fits the customers purposes. Query used to select Jobs in Sequence (thanks to kduke):

select
DS_JOBS.NAME JobName FMT '40L'
FMT '40L'
from
DS_JOBOBJECTS,
DS_JOBS
where
DS_JOBOBJECTS.OLETYPE = 'CJSJobActivity'
and DS_JOBS.NAME = ':1'
and DS_JOBOBJECTS.OBJIDNO = DS_JOBS.JOBNO

;

tnx again.

William