ORACLE_OCM.MGMT_CONFIG dependencies on DBMS_SCHEDULER

Line 29: sys.dbms_scheduler.create_job(

25: */
26: procedure submit_job IS
27: BEGIN
28: IF not job_exists(JOB_NAME) THEN
29: sys.dbms_scheduler.create_job(
30: job_name => JOB_NAME,
31: job_type => 'STORED_PROCEDURE',
32: job_action => 'ORACLE_OCM.MGMT_CONFIG.collect_config',
33: start_date=> SYSTIMESTAMP,

Line 45: sys.dbms_scheduler.create_job(

41: RAISE_APPLICATION_ERROR(-20000,'Cannot resubmit. A job '''|| JOB_NAME
42: || '''already exists.');
43: END IF;
44: IF not job_exists(STATS_JOB_NAME) THEN
45: sys.dbms_scheduler.create_job(
46: job_name => STATS_JOB_NAME,
47: job_type => 'STORED_PROCEDURE',
48: job_action => 'ORACLE_OCM.MGMT_CONFIG.collect_stats',
49: start_date=> SYSTIMESTAMP,

Line 75: sys.dbms_scheduler.create_job(

71: l_instNum v$instance.INSTANCE_NUMBER%TYPE;
72: BEGIN
73: BEGIN
74: IF not job_exists(p_job_name || '_' || inst_id) THEN
75: sys.dbms_scheduler.create_job(
76: job_name => p_job_name || '_' || inst_id,
77: job_type => 'PLSQL_BLOCK',
78: job_action => p_job_action ,
79: start_date => NULL,

Line 88: DBMS_SCHEDULER.SET_ATTRIBUTE (p_job_name || '_' || inst_id,'instance_id',inst_id);

84: BEGIN
85: -- Use the instance_id attribute.
86: -- This may throw exception if not implemented in the version of
87: -- the database. We would be ignoring the exception it that case.
88: DBMS_SCHEDULER.SET_ATTRIBUTE (p_job_name || '_' || inst_id,'instance_id',inst_id);
89: EXCEPTION
90: WHEN OTHERS THEN NULL;
91: END;
92: DBMS_SCHEDULER.ENABLE (p_job_name || '_' || inst_id);

Line 92: DBMS_SCHEDULER.ENABLE (p_job_name || '_' || inst_id);

88: DBMS_SCHEDULER.SET_ATTRIBUTE (p_job_name || '_' || inst_id,'instance_id',inst_id);
89: EXCEPTION
90: WHEN OTHERS THEN NULL;
91: END;
92: DBMS_SCHEDULER.ENABLE (p_job_name || '_' || inst_id);
93: -- Run the job synchronously
94: -- DBMS_SCHEDULER.RUN_JOB(p_job_name || '_' || inst_id,FALSE);
95: COMMIT;
96: END IF;

Line 94: -- DBMS_SCHEDULER.RUN_JOB(p_job_name || '_' || inst_id,FALSE);

90: WHEN OTHERS THEN NULL;
91: END;
92: DBMS_SCHEDULER.ENABLE (p_job_name || '_' || inst_id);
93: -- Run the job synchronously
94: -- DBMS_SCHEDULER.RUN_JOB(p_job_name || '_' || inst_id,FALSE);
95: COMMIT;
96: END IF;
97: EXCEPTION
98: WHEN OTHERS THEN

Line 112: sys.dbms_scheduler.create_job(

108: select instance_number into l_instNum from v$instance;
109: IF l_instNum <> p_inst_num THEN
110: BEGIN
111: IF not job_exists(p_job_name || '_2_' || inst_id) THEN
112: sys.dbms_scheduler.create_job(
113: job_name => p_job_name || '_2_' || inst_id,
114: job_type => 'PLSQL_BLOCK',
115: job_action => p_job_action2 ,
116: start_date => NULL,

Line 125: DBMS_SCHEDULER.SET_ATTRIBUTE (p_job_name || '_2_' || inst_id,'instance_id',inst_id);

121: BEGIN
122: -- Use the instance_id attribute.
123: -- This may throw exception if not implemented in the version of
124: -- the database. We would be ignoring the exception it that case.
125: DBMS_SCHEDULER.SET_ATTRIBUTE (p_job_name || '_2_' || inst_id,'instance_id',inst_id);
126: EXCEPTION
127: WHEN OTHERS THEN NULL;
128: END;
129: DBMS_SCHEDULER.ENABLE (p_job_name || '_2_' || inst_id);

Line 129: DBMS_SCHEDULER.ENABLE (p_job_name || '_2_' || inst_id);

125: DBMS_SCHEDULER.SET_ATTRIBUTE (p_job_name || '_2_' || inst_id,'instance_id',inst_id);
126: EXCEPTION
127: WHEN OTHERS THEN NULL;
128: END;
129: DBMS_SCHEDULER.ENABLE (p_job_name || '_2_' || inst_id);
130: COMMIT;
131: END IF;
132: EXCEPTION
133: WHEN OTHERS THEN

Line 147: DBMS_SCHEDULER.RUN_JOB(JOB_NAME);

143: Runs the configuration collection job now.
144: */
145: procedure run_now IS
146: BEGIN
147: DBMS_SCHEDULER.RUN_JOB(JOB_NAME);
148: DBMS_SCHEDULER.RUN_JOB(STATS_JOB_NAME);
149: COMMIT;
150: END run_now;
151:

Line 148: DBMS_SCHEDULER.RUN_JOB(STATS_JOB_NAME);

144: */
145: procedure run_now IS
146: BEGIN
147: DBMS_SCHEDULER.RUN_JOB(JOB_NAME);
148: DBMS_SCHEDULER.RUN_JOB(STATS_JOB_NAME);
149: COMMIT;
150: END run_now;
151:
152: /*

Line 169: dbms_scheduler.disable(job_name, TRUE);

165: procedure stop_job IS
166: BEGIN
167:
168: BEGIN
169: dbms_scheduler.disable(job_name, TRUE);
170: BEGIN
171: dbms_scheduler.stop_job(job_name, TRUE);
172: EXCEPTION WHEN others THEN
173: IF sqlcode = -27366 THEN NULL; --Suppress job not running error

Line 171: dbms_scheduler.stop_job(job_name, TRUE);

167:
168: BEGIN
169: dbms_scheduler.disable(job_name, TRUE);
170: BEGIN
171: dbms_scheduler.stop_job(job_name, TRUE);
172: EXCEPTION WHEN others THEN
173: IF sqlcode = -27366 THEN NULL; --Suppress job not running error
174: ELSE raise;
175: END IF;

Line 177: dbms_scheduler.drop_job(job_name, TRUE);

173: IF sqlcode = -27366 THEN NULL; --Suppress job not running error
174: ELSE raise;
175: END IF;
176: END;
177: dbms_scheduler.drop_job(job_name, TRUE);
178: EXCEPTION WHEN others THEN
179: IF sqlcode = -27475 THEN NULL; --Suppress job not existing error
180: ELSE raise;
181: END IF;

Line 185: dbms_scheduler.disable(stats_job_name, TRUE);

181: END IF;
182: END;
183:
184: BEGIN
185: dbms_scheduler.disable(stats_job_name, TRUE);
186: BEGIN
187: dbms_scheduler.stop_job(stats_job_name, TRUE);
188: EXCEPTION WHEN others THEN
189: IF sqlcode = -27366 THEN NULL; --Suppress job not running error

Line 187: dbms_scheduler.stop_job(stats_job_name, TRUE);

183:
184: BEGIN
185: dbms_scheduler.disable(stats_job_name, TRUE);
186: BEGIN
187: dbms_scheduler.stop_job(stats_job_name, TRUE);
188: EXCEPTION WHEN others THEN
189: IF sqlcode = -27366 THEN NULL; --Suppress job not running error
190: ELSE raise;
191: END IF;

Line 193: dbms_scheduler.drop_job(stats_job_name, TRUE);

189: IF sqlcode = -27366 THEN NULL; --Suppress job not running error
190: ELSE raise;
191: END IF;
192: END;
193: dbms_scheduler.drop_job(stats_job_name, TRUE);
194: EXCEPTION WHEN others THEN
195: IF sqlcode = -27475 THEN NULL; --Suppress job not existing error
196: ELSE raise;
197: END IF;