Hi,
Could somone please tell me if there is a minimum interval for dbms_job?
I'm working on an 11g environment with a Job which is scheduled every 1 second, but Oracle seems to take leave 5 seconds between runs
I'm aware that anything scheduled every second suggests we have a design flaw, and I know we should be using scheduler, but i'm stuck investigating a legacy production job
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'my_proc;'
,interval => 'SYSDATE+1/86400'
);
COMMIT;
END;
I've tested this with a dummy proc, which simply debugs the start/end of the procedure, it takes a couple of miliseconds, but the next run doesn't execute for 5 seconds.
Is there a Minimum Interval System Setting? I can't find anything relevant?
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
Thanks,
Pete