crontab not executing
Posted on 2014-04-06
this is my shell
dummy=`sqlplus -s 'sakthi_r/gcp_ro_access@(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.19.56)(PORT = 1780))
(SERVER = DEDICATED)
(SERVICE_NAME = DPWGCP)
SET HEA OFF PAGES 0
select count(*) from gcb_dba.gcb_charge_dtls ;
if [ "$dummy" -gt 1 ]; then
# mailx -s "Something bad happened in production" ITPeople.SakthiKumar@dpworld.com
echo "something" | mailx -s "subject" ITPeople.SakthiKumar@dpworld.com
sqlplus 'system/system@dcsss' << EOF
insert into abcd values (1);
and this is my cron tab entry
21,22,23,24,25,26,27,28,29,30,31,45,46,47,48,49,50,51,52,53,54,55 * * * * /home/opctusr1/test/new.ksh >> /home/opctusr1/test/test.log
time of the test.log is changing. but my crontab job is not executing.
when I try to execute normally, it is fine. but only from cron job it is not executing.
Please help me resolve this.