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

Home -> Community -> Usenet -> c.d.o.server -> Re: cron scripting of sql*plus

Re: cron scripting of sql*plus

From: Walter T Rejuney <BlueSax_at_Unforgetable.com>
Date: Wed, 24 Jan 2001 08:37:02 -0500
Message-ID: <3A6EDA7E.B47F66DE@Unforgetable.com>

akkha_at_my-deja.com wrote:
>
> Most probably your environment is not set up properly.
> Run env in your script and then run env in your
> UNIX environment and compare. You may add a line, say,
> . $HOME/.profile in your script (for ksh).
>
> Anthony

Probably not a good idea. .profile scripts normally contain terminal-related commands and cronjobs will choke on these. It would be better to make a standalone script that contains the proper initializations and invoke that script from both .profile and from the cron jobs. Received on Wed Jan 24 2001 - 07:37:02 CST

Original text of this message

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