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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

589 views