[SunHELP] Cronjob not run

Connolly, Michael Michael.Connolly at itt.com
Thu Jun 24 12:04:15 CDT 2004

or put the cron job in user oracle's crontab...


Michael J. Connolly
Worldwide PLM/PDM Manager
ITT Industries, Cannon
617-969-3700 x8302

-----Original Message-----
From: sunhelp-bounces at sunhelp.org [mailto:sunhelp-bounces at sunhelp.org] On
Behalf Of Saily Cedre
Sent: Thursday, June 24, 2004 12:51 PM
To: The SunHELP List
Subject: Re: [SunHELP] Cronjob not run

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

10 11 * * 1-5 . /apps/oracle/.profile &&

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

SunHELP maillist  -  SunHELP at sunhelp.org
SunHELP maillist  -  SunHELP at sunhelp.org

This email and any files transmitted with it are proprietary and intended
solely for the use of the individual or entity to whom they are addressed. If
you have received this email
in error please notify the sender. Please note that any views or opinions
presented in this email are solely those of the author and do not necessarily
represent those of ITT Industries, Inc.
The recipient should check this email and any attachments for the presence of
viruses. ITT Industries accepts no liability for any damage caused by any
virus transmitted by this

More information about the SunHELP mailing list