DBMS Job (to run Every 15 minutes)
537093Oct 24 2006 — edited Oct 24 2006I have a job that needs to be run every 15 minutes, not at 15 minutes from the last one, it must be at the 00, 15, 30 and 45 time of every hour.
dbms_job.submit(op_job_num, 'test_job;', SYSDATE,
'trunc(sysdate, ''MI'') + 1/96');
this script will run every 15 minutes, but just not at 15 minutes of the clock.
Help appreciated.
Thanks