crontab Perl scrip

[mmdallal]

Hello,

how can I run a perl script from crontab?

BR

[mmdallal]

OS is RHEL 4.8

[Vitaly Karasik_1]

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.

[mmdallal]

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

[Ralph Grothe]

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.

[Vitaly Karasik_1]

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

[mmdallal]

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