oracle 禁用job任务

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

SQL> select job_name from dba_scheduler_jobs;

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%';

　

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;可查询到。介绍如下：