[SunHELP] Cronjob not run

[Werth, Dave]

David,

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.

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


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