[SunHELP] Cronjob not run

[Saily Cedre]

You have to run the job as oracle, using the su command:  su - oracle -c

This a real example I have in my server:
15 04 * * *  su - oracle -c
"/usr/oracle/app/oracle/product/9.2.0/src/rm/execute_rm"  >>/usr/tmp/rm 2>&1

where execute_rm has the following instruccions:

sqlplus userid/password<<EOF
    set serveroutput on size 10000;
    execute rm_accounting_log();
EOF

Saily.

----- Original Message -----
From: Nguyen, David M
To: sunhelp at sunhelp.org
Sent: Thursday, June 24, 2004 12:29 PM
Subject: [SunHELP] Cronjob not run


I setup a cron job to run sqlplus oracle utility but it does not run as
desired.  It runs fine if I execute it from CLI. Do I have it setup cron
in crontab?



10 11 * * 1-5 . /apps/oracle/.profile &&
/apps/oracle/product/8.1.7/bin/sqlplus

userid/password @/apps/orascript/checkSTATS.sql > /dev/null 2>&1;



Thanks,
David
_______________________________________________
SunHELP maillist  -  SunHELP at sunhelp.org
http://www.sunhelp.org/mailman/listinfo/sunhelp