[SunHELP] Cronjob not run

Saily Cedre saily at etecsa.net
Thu Jun 24 11:51:14 CDT 2004

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();


----- 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 &&

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

SunHELP maillist  -  SunHELP at sunhelp.org

More information about the SunHELP mailing list