yup
script is getting called. i am redirecting echo statements in a .txt file.

00 05 * * * /svm_wl1/billing/data/server/log/sqlldr.sh > /svm_wl1/billing/data/server/log/sqlldr.txt

this txt file gets modified on the scheduled time.
but data is not getting inserted in the table.

i feel it has something to do with the cron enviroment.
does cron sets up its own enviroment?

i have been facing cron problem for some time now.i write scripts,they run manually but fail in cron.


o/p of sqlldr.txt file is like this:

----------
SVM_WL1_WLN_DATA_USAGE_2006-07-10.txt
----------
------------
SVM_WL1_WLN_DATA_USAGE
------------
------
done
------
Tue Jul 11 05:00:10 IST 2006
------