Job Status in a file

ds_is_fun · Post by **ds_is_fun** » Tue Oct 02, 2007 1:14 pm

How to capture job run status in a file in PX?
I want to know if it run sucessfully/aborted ?

DSguru2B · Post by **DSguru2B** » Tue Oct 02, 2007 1:23 pm

use the dsjob command to get the report of a particular job and then parse out the job status.

ds_is_fun · Post by **ds_is_fun** » Tue Oct 02, 2007 4:20 pm

can we not have something as in server DSGetJobInfo function in PX?
Is running through a command prompt only option to know about status of a job run in PX?

ray.wurlod · Post by **ray.wurlod** » Tue Oct 02, 2007 4:49 pm

You can use the DataStage API functions (such as DSGetJobInfo) in before/after job subroutines in parallel jobs.

ds_is_fun · Post by **ds_is_fun** » Tue Oct 02, 2007 5:12 pm

Im unable to use in after job subroutine from "Job properties". It has a pre-defined list of functions and wouldn't let me add new function.

chulett · Post by **chulett** » Tue Oct 02, 2007 5:39 pm

After you create a new 'Before/After' routine it will show up there.

ArndW · Post by **ArndW** » Tue Oct 02, 2007 5:39 pm

You need to create your own after-job subroutine; and then use a function such as DSGetJobInfo() from inside that subroutine.