I am loading a file to a oracle table every day between 8 a.m and 9 a.m. The file may come at any time between 8 a.m to 9 a.m.
As of now, we are manually checking the file availability and then loading the file into oracle table.
My client is asking us to automate this process. My team is wondering if there is any way we can schedule based on file arrival in a specified location.
Do we have such option available in oracle scheduling?
There is a job scheduler built into oracle.
If you are on oracle 11.2 there is a file watcher which starts on filesystem events.
EDIT:
The job scheduler is perfect to run database internal tasks doing insert, select, update, reorganisation task or other oracle near stuff. If you can link the file as external table. Poll for the file by selecting from external table.
Using cron has always the disadvantage that you must run the task under a privileged account or hard code passwords into the script. But cron is perfect the run os near tasks. Importing files into the database is the border. IMHO its the reason for oracle to introduce file watcher.
