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