Scheduling Job using DBMS_JOBS

Create a Job (run it every day) VARIABLE v_jobnum NUMBER; BEGIN dbms_job.submit(:v_jobnum, ‘MY_STORED_PROCEDURE;’, sysdate,’sysdate+1′); END; print v_jobnum BEGIN DBMS_JOB.SUBMIT(JOB => :jobnumber, WHAT => ‘DBMS_STATS.GATHER_DATABASE_STATS(options => ”GATHER AUTO”);’, NEXT_DATE => to_date(’11:30 01/23/06′,’HH24:MI MM/DD/YY’), INTERVAL => ‘SYSDATE + 1′); COMMIT; END; Running Existing Job While the point is to automate jobs, occasionally you may find you need [...]

Continue reading »