Page 1 of 1

Job Status in a file

Posted: Tue Oct 02, 2007 1:14 pm
by ds_is_fun
How to capture job run status in a file in PX?
I want to know if it run sucessfully/aborted ?

Posted: Tue Oct 02, 2007 1:23 pm
by DSguru2B
use the dsjob command to get the report of a particular job and then parse out the job status.

Posted: Tue Oct 02, 2007 4:20 pm
by ds_is_fun
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?

Posted: Tue Oct 02, 2007 4:49 pm
by ray.wurlod
You can use the DataStage API functions (such as DSGetJobInfo) in before/after job subroutines in parallel jobs.

Posted: Tue Oct 02, 2007 5:12 pm
by ds_is_fun
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.

Posted: Tue Oct 02, 2007 5:39 pm
by chulett
After you create a new 'Before/After' routine it will show up there.

Posted: Tue Oct 02, 2007 5:39 pm
by ArndW
You need to create your own after-job subroutine; and then use a function such as DSGetJobInfo() from inside that subroutine.