Re: SQL Plus from a 'cron'

In article <3v1drl$pi1_at_male.EBay.Sun.COM>, bps9_at_bps9.ebay.sun.com (Ravi Sankar) says:
>
>Hello,
> Is it possible to execute SQL Script from a cron function. I tried, But it is
>giving error. In the function I exported the PATH and I tried to run a shell which contains the following lines
> sqlplus username/passwd _at_sqlscript name.
>The error message in the mail was
>Message 428 not found; No message File for product=SQLPlus, facility=SP2Message 231 not found ...
> If somebody can help,That would be greatly appreciated.
>Thanks
>
>Ravi Sankar (ravi.sankar_at_ebay.sun.com)
>
>
>
When you 'cron'a job you don't inherit any current variables like PATH. So you have to set up the path as well as other variables in the 'cron-shell'. I think that could solve your problem.

Mats Larsson matlar_at_rsv.svskt.se Received on Thu Jul 27 1995 - 00:00:00 CEST