Can you schedule it from Crontab?
try "man crontab" in UNIX.
HTH
Wendy
--- [EMAIL PROTECTED] 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: [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).
__________________________________________________
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: [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).
