Page 1 of 1

Calling After job subroutine

Posted: Mon Jan 15, 2007 1:10 am
by sourabhverma
Hi All,

In a server job, I am loading a sequential file into oracle table. In that job i am also using after job subroutine which is calling a unix script but i want that subroutine to run only if that job is successfully finished.

Please let me know how to achieve that.

Posted: Mon Jan 15, 2007 1:20 am
by I_Server_Whale
You can build a job sequence as below:

Code: Select all

Job_Activity(Your current job) -------> Routine_Activity
Run your routine activity with appropriate trigger to the Job_Activity.

Whale.

Posted: Mon Jan 15, 2007 2:18 am
by kumar_s
What is the version of Datastage you are using? Enable the check box,

Code: Select all

Only run after-job subroutine on successful job completion.
that available in JobProperties.

Posted: Mon Jan 15, 2007 2:24 am
by I_Server_Whale
kumar_s wrote:What is the version of Datastage you are using? Enable the check box,

Code: Select all

Only run after-job subroutine on successful job completion.
that available in JobProperties.
Hmmm.....Good one. I missed that. Thanks !

Whale.

Posted: Mon Jan 15, 2007 4:24 am
by sourabhverma
Thanks kumar_s for the suggestion, Now I am able to achieve my requirement.