Home » RDBMS Server » Server Utilities » Cron OR DBMS_JOB
Cron OR DBMS_JOB [message #72428] Fri, 13 June 2003 09:02 Go to next message
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 Go to previous message
Mahesh Rajendran
Messages: 10708
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.
Previous Topic: sys password
Next Topic: Filler keyword in SQL Loader Release 7.3.4.4.1
Goto Forum:
  


Current Time: Tue Dec 24 08:08:17 CST 2024