Home » RDBMS Server » Server Utilities » sqlloader did not run when schedule at the crontab
sqlloader did not run when schedule at the crontab [message #70105] Mon, 15 April 2002 07:24 Go to next message
Loo Bin Soon
Messages: 8
Registered: April 2002
Junior Member
Hi,
I had created a batch file to execute the
sqlloader to extract data from a flat file to the
database table. After scheduled the batch file to
at the crontab -e, it did not execute at all, but
when I executed in manually, it works.
Is there any setting that i need to include in the
batch file? LIke sqlplus we need to set the PATH
if it is not specified in the environment.
Re: sqlloader did not run when schedule at the crontab [message #70106 is a reply to message #70105] Mon, 15 April 2002 07:49 Go to previous message
Sujit Mahapatra
Messages: 19
Registered: March 2002
Junior Member
Need to see the crontab entry.

But remember that the environment variables that you
specify (in your .profile or manually) is not understood when
run through crontab. So you have to, in your shell
script that runs the sqlloader, explicitly define the
environmental variables. These may be the paths and/or
the filenames. You may have to do an "export" these
variables, if called from another shell.

Revert back if u don't see a solution.

Cheers,

Sujit
Previous Topic: Oracle loading errors
Next Topic: Re: SQL*PLUS LOGIN ISSUE
Goto Forum:
  


Current Time: Mon Mar 04 12:31:14 CST 2024