Check your environment when run from cron. Ensure you have full pathnames to your perl script as quite often the $PATH will not be the same as when you ran it from your shell script.
Also check any other environment variables you are using and ensure they are set from the shell script prior to running your perl script. Regards David Logan Database Administrator HP Managed Services 148 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 - Work +61 417 268 665 - Mobile +61 8 8408 4259 - Fax -----Original Message----- From: N. Kavithashree [mailto:[EMAIL PROTECTED] Sent: Monday, 14 March 2005 5:00 PM To: mysql@lists.mysql.com Subject: regarding cron hi i have a prgrm which dumps the data extracted from the txt file to database. i want to run it using cron daily.i m using mysql as backend. when i run this program using my shell script it will run and insert data into the database. but when i give the same in cron it will not work ? what may be the reason ? i chked for the line is cron....as i hve other shell script for other progms ...they all will run but only this will not run. i hv given like this in cron : 30 12 * * * /ncm/p.sh >> /dev/null 2>&1 the shellscript will run the perl program. if i do sh p.sh then everything works fine. but if i run using cron it will not run. any ideas as to why this is happening? kavitha -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
