Database Administration (MOSC)

MOSC Banner

What is the purpose of the default created in SYS schema FILE_WATCHER job running the FILE_WATCHER_P

edited Mar 9, 2010 10:01PM in Database Administration (MOSC) 3 commentsAnswered
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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center