I would like to run job every five minutes(e.g. 00:05, 00:10, 00:15,.....) using DBMS_JOB. I set next_date parameter to
trunc(sysdate)+1 for tomorrow midnight.
For interval I can user sysdate+5(24*60). But, it will
change every time job runs. Is there a way to get exact
5 minute interval?
thanks for your help