Submit scheduled jobs easily

PLVISION (refer to earlier post) has a neat PACKAGE that makes periodic dbms_job submission very easy.

Amongst OTHERS, you can submit a job USING THE unix cron-like parameters
eg:

plvJOB.submit (
'purge_plv_log', -- <----- name OF job
'purge_plv_log', -- <----- dbms_job.what
'0 0 * * *', -- <----- cron frequency parameter
plvJOB.schedule, -- <----- a CONSTANT to indicate cron pattern above
SYSDATE,
'purge plv log');

WITH THE above line, my purge_plv_job job will run every DAY at 0000
hours (IN 24 HOUR notation).

Links

• Subscribe to this feed