DSXchange

I have a job in the sequence which uses a after job sub routine to kick of a shell script which does an insertion in a table used by another job.

How can I get the status of the script using a routine activity stage (whether it ran successfully or not?)

Thanks in advance.

The after job subroutine does not have a separate status, it's return status sets that of the job. If you need to use the return value of the script from the after job subroutine you could look into setting the user status.

Thanks for the reply Andrw

Can you please elaborate more on setting the user status..

Cheers

The BASIC Programmer's Guide documents the syntax for the DSSetUserStatus() function call, and you can query the value with the DSGetJobInfo() function.