Re: Error when running sqplus script in a crontab

Joe Condle wrote:
>
> I am trying to run a sqlplus script in a crontab. The script run
> perfectly in my unix environment. I thoght all the environmental
> variable were declared but I must be missing something. I am running
> /bin/sh . The error I am getting is:
> Message file spl<lang>.msb not found
> Error 6 initalizing SQL*Plus
>
> I have the path to sqlplus declared.
>
> Any ideas
>
> --
> Joseph P. Condle Jr. condle_at_mars-systems.com Office 412-473-6542
> Senior Systems Engineer Fax 412-473-6538
> Medical ARchival Systems, Inc. (MARS) Pager 412-572-9490
> 1310 Beulah Road Pgh. Pa. 15235 USA

Never run sqlplus directly from the cron. Always use a shell wrapper which runs sqlplus and put the shell wrapper on the cron.

A general rule of thumb is that a binary should never be run from the cron since binaries basically cannot be jobs. Shell scripts can be jobs and therefore are the basic form that should be placed on a cron. Received on Fri Jan 28 2000 - 08:10:59 CST