oracle 禁用job任务

参考(17条消息) Oracle 11g自带的系统Job介绍_oracle11gjob_shayuwei的博客-CSDN博客

?

1	SQL> select job_name from dba_scheduler_jobs;

?

1 2 3 4 5

SQL> set lin 160 SQL> col owner for a10 SQL> col DIRECTORY_NAME for a25 SQL> col DIRECTORY_PATH for a50 SQL> select * from dba_directories where DIRECTORY_NAME like '%OCM_CONFIG%';

　

?

1 2 3 4 5 6 7 8 9 10

set lin 160 col owner for a10 col DIRECTORY_NAME for a25 col DIRECTORY_PATH for a50 SQL> SQL> SQL> SQL> select * from dba_directories where DIRECTORY_NAME like '%OCM_CONFIG%';   OWNER      DIRECTORY_NAME        DIRECTORY_PATH                 ORIGIN_CON_ID ---------- ------------------------- -------------------------------------------------- ------------- SYS    ORACLE_OCM_CONFIG_DIR2    /home/db/oracle/product/19.3.0/ccr/state               1 SYS    ORACLE_OCM_CONFIG_DIR     /home/db/oracle/product/19.3.0/ccr/state               1

　　

Oracle 11g的自带的Job，使用select * from Dba_Scheduler_Jobs;可查询到。介绍如下：