Monday, October 15, 2012

Oracle - [ dbms_scheduler ]

SQL> select owner,job_name,enabled from all_scheduler_jobs;

OWNER                          JOB_NAME                       ENABL
------------------------------ ------------------------------ -----
SYS                            XMLDB_NFS_CLEANUP_JOB          FALSE
SYS                            SM$CLEAN_AUTO_SPLIT_MERGE      TRUE
SYS                            RSE$CLEAN_RECOVERABLE_SCRIPT   TRUE
SYS                            FGR$AUTOPURGE_JOB              FALSE
SYS                            BSLN_MAINTAIN_STATS_JOB        TRUE
SYS                            DRA_REEVALUATE_OPEN_FAILURES   TRUE
SYS                            HM_CREATE_OFFLINE_DICTIONARY   FALSE
SYS                            ORA$AUTOTASK_CLEAN             TRUE
SYS                            FILE_WATCHER                   FALSE
SYS                            PURGE_LOG                      TRUE
APEX_040000                    ORACLE_APEX_DAILY_MAINTENANCE  TRUE

OWNER                          JOB_NAME                       ENABL
------------------------------ ------------------------------ -----
APEX_040000                    ORACLE_APEX_WS_NOTIFICATIONS   TRUE
APEX_040000                    ORACLE_APEX_MAIL_QUEUE         TRUE
APEX_040000                    ORACLE_APEX_PURGE_SESSIONS     TRUE

14 rows selected.


SQL> begin
  2  dbms_scheduler.drop_job(job_name=>'SYS.PURGE_LOG');
  3  end;
  4  /

PL/SQL procedure successfully completed.


SQL> begin
  2  dbms_scheduler.enable('FILE_WATCHER');
  3  end;
  4  /

PL/SQL procedure successfully completed.


SQL> begin
  2  dbms_scheduler.disable('FILE_WATCHER');
  3  end;
  4  /

PL/SQL procedure successfully completed.

0 comentários:

Post a Comment