writing job dependencies shell script

From: elain he <elainhe_at_hotmail.com>
Date: Wed, 18 Feb 2004 22:50:41 -0500
Message-ID: <BAY14-F46yAwLNK7Boi000187c7@hotmail.com>

Hi,
I'm trying to figure out how I can write a shell script that checks the success or failure of DML statements. I have a number of jobs that are dependent on one another. For eg. if JobA fails do not process jobB, and likewise if jobB fails, do not process jobC.

Each job looks like the following:
jobA:
===
#!/bin/ksh

sqlplus << eof
username/password
update tableA set .....
eof

jobB:

#!/bin/ksh

sqlplus << eof
username/password
delete tableB .....
eof

I'm trying to write a simple shell script that does the following checks before executing each job:
#!/bin/ksh

jobA
if [ $? = 0 ];then

     jobB
     if [ $? = 0];then
          jobC
          if [ $? = 0];then
               jobD
          else
               exit
          fi
     else
          exit
     fi
else
     exit

The problem I'm encountering is $? always returns 0 because the sqlplus always completes successfully even though my update or delete statement fails due to rollback seg space or any other issues.

Can someone provide me some pointers on how I can write an error handling routine? If there is a better way of writing this, please let me know.

thanks.

elain

Watch high-quality video with fast playback at MSN Video. Free! http://click.atdmt.com/AVE/go/onm00200365ave/direct/01/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Feb 18 2004 - 21:50:41 CST