DBA Data[Home] [Help]

SYS.DBMS_FEATURE_JOB_SCHEDULER dependencies on DBA_JOBS

Line 30: select count(*) into n1 from dba_jobs;

26: sum1 := sum1
27: || 'JNRA:' || n1
28: || ',JNRU:' || nr_of_jobs;
29:
30: select count(*) into n1 from dba_jobs;
31: sum1 := sum1
32: || ',DJOBS:' || n1;
33: -- Direct per job type counts, i.e of the total number of jobs how many are
34: -- program vs executable vs plsql block vs stored procedure vs chain