| Cron OR DBMS_JOB [message #72428] |
Fri, 13 June 2003 09:02  |
Michele
Messages: 77
Registered: December 2000
|
Member |
|
|
Hello,
I have a question regarding my options. I am not an oracle dba but need I to get this resolved. We have a Solaris box here that needs to load data from a flat file to a table in Oracle on that machine. Now, I have been able to log into the unix box and run sqlldr command with the appopriate parameters control,data etc and load the data...
I would like to schedule this job to run in the middle of the night. I am working on setting up a cron job but haven't had success yet. Then I came across DBMS_JOB package. I am not familiar with this so my question is, can I accomplish this using DBMS_JOB? And if so what is the desired option CRON OR DBMS_JOB?
Thank You
Michele
|
|
|
|
| Re: Cron OR DBMS_JOB [message #72429 is a reply to message #72428] |
Fri, 13 June 2003 09:27  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
IN this case i would go for CRON.
becuase to for DBMS_JOB needs a stored procedure.
to write a stored procedure to utilize os utilities like sqlldr, you need to do some work.
it would be just simple to use the cron.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
