[SunHELP] Cronjob not run

Werth, Dave dave.werth at garmin.com
Thu Jun 24 11:52:01 CDT 2004


In the past whenever I've needed to run sqlplus through cron I've always put
it in a script and run that.  For example:

#! /bin/ksh
export DASQL=/data/ora2/stats/awkscr/tablesn_sql
sqlplus -SILENT userid/password @$DASQL/.save/tables.sql

And start it with a line like this:
30 00 * * 0 su - root -c /path/script > /dev/null 2>&1

Hope this helps.

David Werth
Garmin AT, Inc
(formerly: UPS Aviation Technologies)
(formerly: II Morrow)
Salem, Oregon
dave.werth at garmin.com

-----Original Message-----
From: Nguyen, David M [mailto:david.m.nguyen at xo.com] 
Sent: Thursday, June 24, 2004 9:30 AM
To: sunhelp at sunhelp.org
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

This e-mail and any attachments may contain confidential material for the sole use of the intended recipient.  If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited.  If you have received this e-mail in error, please contact the sender and delete all copies. 
Thank you for your cooperation 

More information about the SunHELP mailing list