What is the purpose of the default created in SYS schema FILE_WATCHER job running the FILE_WATCHER_P
What is the purpose of the default created in SYS schema FILE_WATCHER
job running the FILE_WATCHER_PROGRAM programm? Is it used in any way
with user defined scheduler watchers?
SQL> select job_name, state, program_name, enabled,LAST_START_DATE, NEXT_RUN_DATE from dba_scheduler_jobs where job_name='FILE_WATCHER';
JOB_NAME STATE PROGRAM_NAME ENABL LAST_START_DATE
------------------------------ --------------- ------------------------------ ----- ---------------------------------------------------------------------------
NEXT_RUN_DATE
---------------------------------------------------------------------------
FILE_WATCHER SCHEDULED FILE_WATCHER_PROGRAM TRUE 19-FEB-10 09.59.21.139344 AM EUROPE/VIENNA
19-FEB-10 10.09.21.000000 AM EUROPE/VIENNA
SQL> select PROGRAM_NAME,PROGRAM_TYPE,PROGRAM_ACTION,NUMBER_OF_ARGUMENTS,ENABLED,COMMENTS from dba_scheduler_programs where PROGRAM_NAME='FILE_WATCHER_PROGRAM';
SQL> select job_name, state, program_name, enabled,LAST_START_DATE, NEXT_RUN_DATE from dba_scheduler_jobs where job_name='FILE_WATCHER';
JOB_NAME STATE PROGRAM_NAME ENABL LAST_START_DATE
------------------------------ --------------- ------------------------------ ----- ---------------------------------------------------------------------------
NEXT_RUN_DATE
---------------------------------------------------------------------------
FILE_WATCHER SCHEDULED FILE_WATCHER_PROGRAM TRUE 19-FEB-10 09.59.21.139344 AM EUROPE/VIENNA
19-FEB-10 10.09.21.000000 AM EUROPE/VIENNA
SQL> select PROGRAM_NAME,PROGRAM_TYPE,PROGRAM_ACTION,NUMBER_OF_ARGUMENTS,ENABLED,COMMENTS from dba_scheduler_programs where PROGRAM_NAME='FILE_WATCHER_PROGRAM';
0