Calling After job subroutine

sourabhverma · Post by **sourabhverma** » Mon Jan 15, 2007 1:10 am

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.

I_Server_Whale · Post by **I_Server_Whale** » Mon Jan 15, 2007 1:20 am

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.

kumar_s · Post by **kumar_s** » Mon Jan 15, 2007 2:18 am

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.

I_Server_Whale · Post by **I_Server_Whale** » Mon Jan 15, 2007 2:24 am

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.

sourabhverma · Post by **sourabhverma** » Mon Jan 15, 2007 4:24 am

Thanks kumar_s for the suggestion, Now I am able to achieve my requirement.