DBA Data[Home] [Help]

ORACLE_OCM.MGMT_CONFIG dependencies on DBA_SCHEDULER_JOBS

Line 13: dba_scheduler_jobs WHERE job_name = job_name_in and owner ='ORACLE_OCM';

9: FUNCTION job_exists (job_name_in VARCHAR) RETURN BOOLEAN IS
10: l_job_cnt NUMBER;
11: BEGIN
12: select count(*) into l_job_cnt from
13: dba_scheduler_jobs WHERE job_name = job_name_in and owner ='ORACLE_OCM';
14: if l_job_cnt = 0
15: THEN
16: return FALSE;
17: ELSE