Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Unix batch job

Unix batch job

From: <U.CHANDER_at_ponl.com>
Date: Fri, 05 Oct 2001 00:44:01 -0700
Message-ID: <F001.003A2F02.20011005002019@fatcity.com>

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: ORACLE-L_at_fatcity.com
Sender: root_at_fatcity.cts.com
Reply-To: ORACLE-L_at_fatcity.com
Reply-Copies-To: ML-ERRORS_at_fatcity.com

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: Roland.Skoldblom_at_ica.se

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: ListGuru_at_fatcity.com (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: U.CHANDER_at_ponl.com 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: ListGuru_at_fatcity.com (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).
Received on Fri Oct 05 2001 - 02:44:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US