Here is one simple example:
==================================
SUCCESS=0
STARTTIME=`date +'%d/%m/%Y-%H:%M:%S'`
BATCHEXECUABALE ARGUMENT1 ARGUMENT2 <INPUT_FILE >>OUTPUT_FILE
EXITSTATUS="�?"
ENDTIME=`date +'%d/%m/%Y-%H:%M:%S'`
if ^ "�{EXITSTATUS}" = "�{SUCCESS}" ]
then
echo "BATCHEXECUABALE Succeeded"
else
echo "BATCHEXECUABALE failed with exit code �{EXITSTATUS}"
fi
echo "BATCHEXECUABALE �{EXITSTATUS} �{STARTTIME} �{ENDTIME}" >> BATCH_RUNLOG
=======================
HTH.
Umesh
------------------( Forwarded letter 1 follows )---------------------
Date: Thu, 04 Oct 2001 22:55:17 -0800
To: [EMAIL PROTECTED]
Sender: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Reply-Copies-To: [EMAIL PROTECTED]
Hallo,
Anyone whom can give me a good example on how to write in a unix script if I want to
run sqlloader every Sunday at 6 o clock pm?
Please give me an example.
Thanksin advance.
Roland Sk�ldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
-------------------------------------------------------------------
The contents of this e-mail are confidential to the ordinary user
of the e-mail address to which it was addressed and may also be
privileged. If you are not the addressee of this e-mail you should
not copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this e-mail in error
please notify us by telephone or e-mail the sender by replying to
this message, and then delete this e-mail and other copies of it
from your computer system. Thank you.
We reserve the right to monitor all e-mail communications through
our network.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
