Can you schedule it from Crontab?
try "man crontab" in UNIX.
HTH
Wendy
- U.CHANDER_at_ponl.com wrote:
> 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).
Do You Yahoo!?
NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Wendy Y
INET: wlyue2001_at_yahoo.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 - 11:00:52 CDT
