Check for changes every 10 seconds filewatcher

#Check for changes every 10 seconds filewatcher code#

It is logged because in case of external job the credentials are used by the job itself. The good thing when running an external job is, that the reason why it failed is logged and you can see it in the USER_SCHEDULER_JOB_RUN_DETAILS view.

I referenced to the thread with external job, because the issue there was the same. rwxr-xr-x 1 root root 51904 06:31 libpam.so.0.81.12*We are running Suse linuxДescription: SUSE Linux Enterprise Server 11 (x86_64)Д¬odename: n/aBefore making this link I think Oracle even didn't try to connect to the system (I didn't find any logs in /var/log/messages). Lrwxrwxrwx 1 root root 11 16:33 libpam.so -> libpam.so.0* Now on our system in /lib64 it looks like: So the problem was the missing symbolic link. After creating the symbolic link to for libpam.so.0 the file watcher started to work. Maybe I was not exact in my previous post. I think because the watcher relies on creation date of a file, the lowest possible value would be 2 minutes.ДЄm I right or is it somehow possible to make the interval lower than a minute? The problem is that even when setting this, the file watcher is not checking the folder every 2s. According to the documentation here:ДBMS_SCHEDULER.SET_ATTRIBUTE(Name => 'FILE_WATCHER_SCHEDULE', By default the file watcher checks the presence of new file every 10 minutes. So if I copy some file created yesterday into target folder, it will not trigger the file watcher. What I found is that the watcher is relying on the date and time when the file was created. I recreated all objects and it seems to be working somehow. If you are creating a file watcher, the credentials are bounded to the file watcher and there is no view or something where you could find whats wrong. Ln -s /lib64/libpam.so.0 /lib64/libpam.soThe stupid thing thing is that if you create an external job and if fails for some reason (in this case the credentials are bounded to directly to the job), you will see an error in USER_SCHEDULER_JOB_RUN_DETAILS because the job ran and failed for some reason. STANDARD_ERROR='Launching external job failed: Invalid username or password''ДЄfter creating of symbilic link the external job started to work ORA-27369: Гєloha typu EXECUTABLE selhala s kГіdem ukonВїenГ: Argument list too long SELECT * FROM USER_SCHEDULER_JOB_LOG STATUS = FAILED I am also running on linux, so I tried to create a job running an external script and also got the error about autentication. SELECT * FROM USER_SCHEDULER_JOBS JOB_NAME = EOD_JOBДЄfter many hours of reading documentation, running everything again from beginning and searching the internet, I found this thread: Still nothing happens when move some file (e.g.

#Check for changes every 10 seconds filewatcher code#

Payload.directory_path || '/' || payload.actual_file_name,ДЇile_watcher_name => 'eod_reports_watcher',Дirectory_path => '/home/xxxxx/xxxxx/xxxx/xxxx/xxxxx/xxxx/xxxxx',Дbms_t_attribute('eod_job','parallel_instances',true) Д®xec dbms_scheduler.enable('eod_reports_watcher,eod_job') I did three changes to the code in comparison with the exampleДЎ) Changed username and password in the credentials (username and password which I use for login to the OS)Дў) Changed directory path for the file watcher (I started the directory path with the /home/.)ДЈ) Set the event_condition parameter to NullДЇinally I ran this as SYS to make the watcher check the folder every second:ДBMS_SCHEDULER.SET_ATTRIBUTE('FILE_WATCHER_SCHEDULE', 'REPEAT_INTERVAL', (payload IN sys.scheduler_filewatcher_result) as NLSRTL Version 11.2.0.1.0 - ProductionAfter solving this for several hours I just copied the example which is at the end of the tutorial and ran it.Д¬reate table eod_reports (when timestamp, file_name varchar2(100), TNS for Linux: Version 11.2.0.1.0 - Production Oracle Database 11g Release 11.2.0.1.0 - 64bit Production What I need to do is to run a job when a file arrives to some specific folder. I need a help with Oracle Scheduler again.

1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.9K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database.