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...
Retrieving Job Status through Universe stage
Moderators: chulett, rschirm, roy
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:The correct way of getting the status is to use the DSGetJobInfo() routine instead of looking at the status file contents
SELECT NAME
FROM DS_JOBS
WHERE STATUS <> 'Ok'
or alike....
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):
tnx again.
William
;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