Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Task scheduler fails on running batch file for sql loader

Christian PitetJun 18 2021 — edited Jun 18 2021

I Have created a batch file for running sql loader. I am under Windows server 2012. If I invoke it from the command line it work fine :

C:\app\oracle\product\12.1.0\dbhome_1\BIN\sqlldr.exe control = F:\Oracle\Scripts\load_export.ctl userid=sivoa/SIVOA ERRORS=1000000 LOG=F:\Oracle\Scripts\load_export.log, BAD=F:\Oracle\Scripts\load_export.bad

But when I run it from the Windows task scheduler I get an error 0x1.
As a turn around I could perhaps try to run the batch file from the DBMS Scheduler ? But I don't know how to do it.
Best regards,
Christian

Added on Jun 18 2021

#database-key-features, #export-import-sql-loader-external-tables

8 comments

697 views