How to
submit, run, and remove a job?
As
a programmer you have been assigned to submit a job to run a stored procedure
called “clean_the_tables” every one hour in Oracle.
By:
John Kazerooni
--
Define “v_jobno” as a binding variable:
VARIABLE
v_jobno NUMBER
--
Submit the job.
EXECUTE
dbms_job.submit (:v_jobno, ‘clean_the_tables;’, sysdate, ‘sysdate + (1/24)’);
--
Print the job number
PRINT
v_jobno
-OR-
SELECT
:v_jobno FROM dual;
-OR-
SELECT
job FROM user_jobs ORDER BY job; -- the last number.
--
Run the job.
EXECUTE
dbms_job.run (:v_jobno);
--
Remove the job.
EXECUTE
dbms_remove(:v_jobno);
|