hi,
i have schduled a job through crontab, but it is not getting executed.
bash-3.2$ crontab -l
# Monthly Download (mm hh DD MM format)
35 05 01 04 * /home/ftpsrp/srpftp1/download/ofrdb/scripts/load_ofrdb.sh crr.sh
here is the permission of the .sh files
-rwxr--r-- 1 ftpsrp srp 9433 Apr 1 04:07 load_ofrdb.sh
-rwxr--r-- 1 ftpsrp srp 12217 Apr 26 2007 crr.sh
what do i need to check here, please suggest??
its urgent so any quick reply is highly appriciated.
Did it start and crash, or did it just simply not run? Check the system log files for cron entries. It's wise to create and keep an error log file redirecting stderr to a file...
it didn't get start because logfile has not been modified.
-rw-r--r-- 1 ftpsrp srp 16779 Mar 26 01:01 load_ofrdb.crr.sh.log
how could i check the system log files for cron entries?
If you have the permissions, less or grep cron the log files in /var/log , e.g. messages.
now i tried to run the file manually then i got below message:
bash-3.2$ sh load_ofrdb.sh crr.sh
load_ofrdb.sh: syntax error at line 4: `ORACLE_HOME=$' unexpected
So - did the cron job start and crash, or did it plainly not run?
it seems that cron starts but ended up with some error, i checkd the email in cat /var/mail//ftpsrp
From ftpsrp@usa0300uz1180.apps.mc.xerox.com Mon Apr 1 09:27:02 2013
Return-Path: <ftpsrp@usa0300uz1180.apps.mc.xerox.com>
Received: from usa0300uz1180.apps.mc.xerox.com (localhost [127.0.0.1])
by usa0300uz1180.apps.mc.xerox.com (8.14.4+Sun/8.14.4) with ESMTP id r31DR2LG007245
for <ftpsrp@usa0300uz1180.apps.mc.xerox.com>; Mon, 1 Apr 2013 09:27:02 -0400 (EDT)
Received: (from ftpsrp@localhost)
by usa0300uz1180.apps.mc.xerox.com (8.14.4+Sun/8.14.4/Submit) id r31DR2vk007225
for ftpsrp; Mon, 1 Apr 2013 09:27:02 -0400 (EDT)
Date: Mon, 1 Apr 2013 09:27:02 -0400 (EDT)
From: Supplies Reporting FTP <ftpsrp@usa0300uz1180.apps.mc.xerox.com>
Message-Id: <201304011327.r31DR2vk007225@usa0300uz1180.apps.mc.xerox.com>
To: ftpsrp@usa0300uz1180.apps.mc.xerox.com
Subject: Output from "cron" command
MIME-Version: 1.0
Content-Type: text/plain
Content-Length: 166
Your "cron" job on usa0300uz1180
/home/ftpsrp/srpftp1/download/ofrdb/scripts/load_ofrdb.sh crr.sh
produced the following output:
stty: : No such device or address
and in .profile file here is the code for stty stty erase '^?'
please help
A cron job does not have a terminal associated to it, so those commands must fail. Sourcing your .profile in the cron job is a good idea, on the other hand, as your script will have all your environment variables at its disposal, should it need them. You may need to split .profile into one general part and one part for interactive logins that cron would skip, then.