[SunHELP] Cronjob not run

[Connolly, Michael]

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

Regards,

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();
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
_______________________________________________
SunHELP maillist  -  SunHELP at sunhelp.org
http://www.sunhelp.org/mailman/listinfo/sunhelp

************************************
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
email.
************************************