how to get a job's execution result

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
WoMaWil
Participant
Posts: 482
Joined: Thu Mar 13, 2003 7:17 am
Location: Amsterdam

Post by WoMaWil »

Hi little hope,

"chen" at the end of a word in german means little.

Siply read the docu about dsjob and you see all details. One problem is whem job run longer than an our you may get jobstatus 141, which is no error.

Wolfgang
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Chen is a reasonably common name in Taiwan, where the poster lives.

There are three main mechanisms for getting the result from dsjob.

Since it is a well-formed UNIX executable, it does generate an exit status. This can be accessed through $?, for example:
dsjob -listprojects
echo $?

However, I suspect Ms Chen seeks the exit status from the DataStage job, which is started asynchronously (unless the -wait or -jobstatus option is used when the primary subcommand is -run). For example:
dsjob -run -jobstatus projectname jobname

Use the dsjob -jobinfo command to return all the information about the job; one of these items of information is the DataStage completion status. For example:
dsjob -jobinfo projectname jobname
Post Reply