0 Replies Latest reply on Apr 27, 2012 7:15 AM by 933629

    Unexpected Messages in SYS.SCHEDULER_FILEWATCHER_Q


      I am testing the file watcher functionality in 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?