I am testing the file watcher functionality in 220.127.116.11 with a destination on the local server. For my test I followed the tutorial on http://www.oracle-base.com/articles/11g/scheduler-enhancements-11gr2.php#file_watcher.
First of all the good news always when a file arrives the expected procedure will be called. But when I query the file watcher queue I see messages in the state READY. The unprocessed messages belongs to the event queue agent which is registered with my file watcher job. select consumer_name from aq$scheduler_filewatcher_qt where msg_state = 'READY'; select event_queue_agent from dba_scheduler_jobs where job_name = '<job>';
Does anyone have any idea why I see these unprocessed messages in the file watcher queue?