topic Re: crontab Perl scrip in Operating System - Linux

crontab Perl scrip

mmdallal — Wed, 16 Feb 2011 08:17:38 GMT

Hello,

how can I run a perl script from crontab?

BR

Re: crontab Perl scrip

mmdallal — Wed, 16 Feb 2011 08:19:51 GMT

OS is RHEL 4.8

Re: crontab Perl scrip

Vitaly Karasik_1 — Wed, 16 Feb 2011 08:58:17 GMT

exactly as you do this from your command line.
just be sure you have full path to perl binary in your command or in the first line of your script.

Re: crontab Perl scrip

mmdallal — Thu, 17 Feb 2011 07:03:15 GMT

Hi Vitaly,

in cron:

* * * * * /u01/app/oracle/product/10.2.0/db_1/perl/bin/perl /usr/OVPI/connect.pl >>& /usr/OVPI/test_perl.txt

does not write any in the file /usr/OVPI/test_perl.txt

but when I run it in the shell it is OK

BR

Re: crontab Perl scrip

Ralph Grothe — Thu, 17 Feb 2011 12:27:32 GMT

Maybe merely a typo, the position of the ampersand?
Do you realy mean to background the connect.pl command?
Or did you just want to redirect both stdout and stderr to test_perl.txt?
Then I think it would have to be

* * * * * /u01/app/oracle/product/10.2.0/db_1/perl/bin/perl /usr/OVPI/connect.pl &>>/usr/OVPI/test_perl.txt

But check with man bash in the section REDIRECTIONS if this abbreviated syntax is valid.

Re: crontab Perl scrip

Vitaly Karasik_1 — Thu, 17 Feb 2011 14:10:44 GMT

please check email of crontab's owner - you should see the error.

and AFAIK it should be

/u01/app/oracle/product/10.2.0/db_1/perl/bin/perl /usr/OVPI/connect.pl >> /usr/OVPI/test_perl.txt

Re: crontab Perl scrip

mmdallal — Thu, 17 Feb 2011 19:40:34 GMT

hello,

the problem is resolved when I fixed the Oracle home environment variables in the perl script, as follow:
------------
BEGIN {
unless ($ENV{ORACLE_PERL}) {
$ENV{ORACLE_HOME} = "/u01/app/oracle/product/10.2.0/db_1";
$ENV{ORACLE_PERL} = "$ENV{ORACLE_HOME}/perl";
$ENV{PERL5LIB} = "$ENV{PERL5LIB}:$ENV{ORACLE_PERL}/lib:$ENV{ORACLE_PERL}/lib/site_perl";
$ENV{LD_LIBRARY_PATH} = "$ENV{LD_LIBRARY_PATH}:$ENV{ORACLE_HOME}/lib32:$ENV{ORACLE_HOME}/lib";
exec "$ENV{ORACLE_PERL}/bin/perl", $0, @ARGV;
}
}

------------

Thank you all