Very Computer

Hi,

I have set up a cron job which connects to the oracle database using SQL*Plus.
The jobs runs ok when I run the job manually.

The error message is:
Message file sp1<lang>.msb not found
Error 6 initializing SQL*Plus

*****************************************************************
        cron: The previous message is the standard output
        and standard error of one of the cron commands.

Please  let me know what this means and how I can get rid of it?

Thanx

Quote:> Hi,

> I have set up a cron job which connects to the oracle database using
SQL*Plus.
> The jobs runs ok when I run the job manually.

> The error message is:
> Message file sp1<lang>.msb not found
> Error 6 initializing SQL*Plus

> *****************************************************************
>         cron: The previous message is the standard output
>         and standard error of one of the cron commands.

> Please  let me know what this means and how I can get rid of it?

Short answer:
Create a correct runing script ;-)

Long answer:
cron sends stdout and stderr from a script to the crontabs owner since no
tty is associated
To get rid of it you can do redirect the output of your script, aka:
1>/dev/null 2>&1
That would be the M$ error solution.

Please keep in mind that cron uses its own environment. which is not
nessesary the same like yours.
So create in your script the correct environment  - path, db settings
a.s.o - and your cron message will go away

HTH

Hajo
CATE AIX/RS6000

Quote:

> Hi,

> I have set up a cron job which connects to the oracle database using SQL*Plus.
> The jobs runs ok when I run the job manually.

> The error message is:
> Message file sp1<lang>.msb not found
> Error 6 initializing SQL*Plus

> *****************************************************************
>         cron: The previous message is the standard output
>         and standard error of one of the cron commands.

> Please  let me know what this means and how I can get rid of it?

> Thanx

One of the things cron needs is the full path for each executable, unless
you do as Hans-Joachim said and set cron's path in the script.

Alan C