| sqlloader did not run when schedule at the crontab [message #70105] |
Mon, 15 April 2002 07:24  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
