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