Excel file will be uploaded by the users for every 10 days by logging into the windows server , they will simply put the file in windows directory[like say in c:\MyFiles\Myfile1\]. Java code will be executed for every 5min to check whether there is new file has came or not in that path. File will contain 5K to 7K employee records.
So we need to re-write this functionality in the oracle through DBMS_scheduler File watcher and scheduler job.
My DB Ver:
Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 - 64bit Production
PL/SQL Release 18.104.22.168.0 - Production
CORE 22.214.171.124.0 Productio
I came across the file watcher in DBMS_Scheduler,
Please suggest how can implement this through DBMS_Scheduler
MY Oracle DB is residing on another server and File will be on
another server.Can I fetch the file which is on the remote machine
and I will have credentials to login.
Is there any extra steps to be done at config level, before going
to schedule the job.