Home » Infrastructure » Windows » please tell me how to schedule a job for sqlldr? (Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production, Windows server)
please tell me how to schedule a job for sqlldr? [message #438981] Wed, 13 January 2010 06:47 Go to next message
lungibaba
Messages: 9
Registered: January 2010
Location: Delhi
Junior Member
please tell me how to schedule a job for sqlldr?

below is my control file,which is just transfering data from a flat file to a oracle table.

load data
infile '\\172.21.176.67\shared\testingdata.psv'
append
into table CUB_NEW
fields terminated by "|"
(BRANCH_CODE,CLOS_BALS,OPEN_BAL)

i want to run dis daily with different filenames.
Re: please tell me how to schedule a job for sqlldr? [message #438986 is a reply to message #438981] Wed, 13 January 2010 07:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use Windows scheduler, winat or any other scheduler.

Regards
Michel
Re: please tell me how to schedule a job for sqlldr? [message #439042 is a reply to message #438981] Wed, 13 January 2010 12:53 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
lungibaba wrote on Wed, 13 January 2010 13:47
i want to run dis daily with different filenames.

Well, "different filenames" is something you'll probably regret. As you don't know how to schedule a job, perhaps (I hope not!) you'll find it difficult to adjust your programs to that requirement. Because, SQL*Loader control file can't be set to dynamically change INFILE file name. Therefore, you'll either have to rename input file to the one set in control file, or dynamically create control file before loading session.

By far, the simplest option is to use the same file name all the time. But OK, it's up to you, I sincerely hope you'll manage to make it work.

By the way, scheduling a job is piece of cake when compared to the above.

[Updated on: Wed, 13 January 2010 12:55]

Report message to a moderator

Re: please tell me how to schedule a job for sqlldr? [message #439226 is a reply to message #438981] Fri, 15 January 2010 01:34 Go to previous messageGo to next message
lungibaba
Messages: 9
Registered: January 2010
Location: Delhi
Junior Member
i hav tried it with task scheduler:-

control panel-->schedule tasks-->add scheduler task-->program(command prompt)-->select time and frequency-->finish.

but i was not to write my sqlldr script. how to schedule the script below.
sqlldr userid=abc/xyz@testdb control=aaa_test.ctl log=log.txt bad=rejected_records.txt
Re: please tell me how to schedule a job for sqlldr? [message #439228 is a reply to message #439226] Fri, 15 January 2010 01:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Put all your commands in a .cmd file and select it when the assistant asks you.

Regards
Michel
Re: please tell me how to schedule a job for sqlldr? [message #439230 is a reply to message #438981] Fri, 15 January 2010 02:00 Go to previous message
lungibaba
Messages: 9
Registered: January 2010
Location: Delhi
Junior Member
thanks Michel, i think this will work.
Previous Topic: %1 is not a valid win32 application
Next Topic: ODBC numeric settings
Goto Forum:
  


Current Time: Thu Mar 28 04:22:07 CDT 2024