96: END IF;
97: EXCEPTION
98: WHEN OTHERS THEN
99: -- Don't raise an exception otherwise it fills the alert/trace
100: DBMS_OUTPUT.put_line('Do not raise an exception');
101: -- RAISE_APPLICATION_ERROR(-20000,'SQLERRM: ' || SQLERRM || ' SQLCODE: '|| SQLCODE);
102: END;
103:
104: -- create 2nd job if specified
131: END IF;
132: EXCEPTION
133: WHEN OTHERS THEN
134: -- Don't raise an exception otherwise it fills the alert/trace
135: DBMS_OUTPUT.put_line('Do not raise an exception');
136: END;
137: END IF;
138: END IF;
139: END IF;
153: Print the job details.
154: */
155: procedure print_job_details IS
156: BEGIN
157: dbms_output.put_line('Configuration collection job name: ' || JOB_NAME);
158: dbms_output.put_line('Statistics collection job name: ' || STATS_JOB_NAME);
159: dbms_output.put_line('Job Schedule: DAILY');
160: END print_job_details;
161:
154: */
155: procedure print_job_details IS
156: BEGIN
157: dbms_output.put_line('Configuration collection job name: ' || JOB_NAME);
158: dbms_output.put_line('Statistics collection job name: ' || STATS_JOB_NAME);
159: dbms_output.put_line('Job Schedule: DAILY');
160: END print_job_details;
161:
162: /*
155: procedure print_job_details IS
156: BEGIN
157: dbms_output.put_line('Configuration collection job name: ' || JOB_NAME);
158: dbms_output.put_line('Statistics collection job name: ' || STATS_JOB_NAME);
159: dbms_output.put_line('Job Schedule: DAILY');
160: END print_job_details;
161:
162: /*
163: Stop (and drop) the job.