.------[ Mark Martin wrote (2002/08/29 at 14:54:30) ]------
|
| I'm concious that this might be a Linux problem but maybe someone on the
| list has had the same issue and solved it.
|
| I copied out below one of the simplest functions from a perl script that I
| need to schedule every day. When I run it interactively the table truncates
| fine and I get all the print statements. However when I try to run it as a
| cron job nothing happens to the table and I only get the first print
| statement in a log file - but the script compiles without error and Oracle
| doesn't feed back any errors either.
|
| Here is the cron command :
|
| 00 00 * * * perl /pathtofile/script.pl 2>&1 >> /pathtologfile/logfile.txt
| (Running on Linux 7.2 and I've tried is as a standard user and as root)
|
| Here is the script :
|
| #!/usr/bin/perl print "\n\n *********** CRONTEST ****************\n\n";
| use DBI; use DBD::Oracle; $dbh1 = DBI->connect( "dbi:Oracle:dbase", "user",
| "pword" ) or die "Can't connect to Oracel database: $DBI::errstr\n";
| print "\n\n *********** LOGGED IN OK ****************\n\n"; my $sqlA =
| qq{TRUNCATE TABLE TABLE_NAME};
| my $sth1 = $dbh1->prepare($sqlA) or die "Can't prepare SQL statement:
| $DBI::errstr\n";
| $sth1->execute or die "Can't execute SQL statement: $DBI::errstr\n";
| $dbh1 ->disconnect();
| print "\n\n *********** LOGGED OUT OK ****************\n\n";
| exit;
|
`-------------------------------------------------
You'll need to make sure that CRON has all the same environment
variables and is running as the same user as when you are running
it by hand. I would wager that this is the problem.
---------------------------------
Frank Wiles <[EMAIL PROTECTED]>
http://frank.wiles.org
---------------------------------
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]