Skip to Main Content

FILE WATCHER - JOB IS NOT RUNNING

Ramin HashimzadehMar 7 2014 — edited Mar 14 2014

Hi All.

I have below problem with dbms_scheduler,  file watcher job.

I am creating file watcher like this :

BEGIN

  dbms_scheduler.create_credential(credential_name => 'cred_file_watcher',

                                   username        => 'test',

                                   password        => 'test');

                 

  dbms_scheduler.create_program(program_name        => 'prog_file_watcher',

                                program_type        => 'stored_procedure',

                                program_action      => 'rr_app_am.am_pack_ott_box.load_ott_boxes',

                                number_of_arguments => 1,

                                enabled             => FALSE);     

  dbms_scheduler.define_metadata_argument(program_name       => 'prog_file_watcher',

                                          metadata_attribute => 'event_message',

                                          argument_position  => 1);

                    

                    

  dbms_scheduler.create_file_watcher(file_watcher_name => 'file_watcher',

                                     directory_path    => 'D:\AMIN',

                                     file_name         => '*.txt',

                                     credential_name   => 'cred_file_watcher',

                                     destination       => NULL,

                                     enabled           => FALSE);

  dbms_scheduler.create_job(job_name        => 'job_file_watcher',

                            program_name    => 'prog_file_watcher',                           

                            event_condition => NULL,

                            queue_spec      => 'file_watcher',

                            auto_drop       => FALSE,

                            enabled         => FALSE);

                          

  dbms_scheduler.enable('file_watcher, prog_file_watcher, job_file_watcher');

END;

and JOB is not running. When i am trying to run it manually , ORACLE return error

SQL> begin

  2   dbms_scheduler.run_job('JOB_FILE_WATCHER');

  3  end;

  4 

  5  /

begin

dbms_scheduler.run_job('JOB_FILE_WATCHER');

end;

ORA-00942: table or view does not exist

ORA-06512: at "SYS.DBMS_ISCHED", line 185

ORA-06512: at "SYS.DBMS_SCHEDULER", line 486

ORA-06512: at line 2


--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

I looked this threads

file watcher is not working in 11g R2

Stuck with filewatcher

but can not find solution. Can you help me.

Thanks!

----

Ramin Hashimzade

Comments
Post Details
Added on Mar 7 2014
14 comments
5,545 views