| please tell me how to schedule a job for sqlldr? [message #438981] |
Wed, 13 January 2010 06:47  |
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 #439042 is a reply to message #438981] |
Wed, 13 January 2010 12:53  |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
lungibaba wrote on Wed, 13 January 2010 13:47i 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 |
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
