Re: problem with oracle and AT command

Hi,
check your environment variables. There are differences running a command from commandline and from cron via at command. Put an 'env>/tmp/envfile' into your script and check afterwards the contents. Possibly the oracle-related variables are missing, if they are set up in your .profile.
HTH
Michael
Cyril Caillaud wrote:
>
> Hi
>
> I have a problem with Oracle and the AT schedule-command,
>
> I've created a batch with a few Oracle commands inside and it works great
> when I run it manually;
> however when I create a schedule to launch this batch, nothing happens.
>
> does anybody have an idea ?
>
> the batch file load data in the database and execute procedure.
>
> the batch file.
>
> >sqlldr73 xxx/yyy_at_zzz control=charge_clients.ctl >log=charge_clients.log
 

> >sqlldr73 xxx/yyy_at_zzz control=charge_produits.ctl >log=charge_produits.log
 

> >sqlplus xxx/yyy_at_zzz @essai.sql
>
> end batch file
>
> essai.sql file
>
> >execute import;
> >exit;
>
> end essai.sql
>
> Cyril Caillaud
> ----------------------------------------------------------
> Cyril Caillaud
> Netvalley cyril.caillaud_at_netvalley.fr
> http://www.netvalley.fr
  Received on Mon Feb 16 1998 - 00:00:00 CST