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).
0 Comments:
Post a Comment
<< Home