Job doesnt work in five minutes intervals
451321Jan 25 2008 — edited Jan 28 2008Hi,
i have a job which has to work in five minutes. It can be seen below:
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'begin
pck_evr_msg.mailer;
end;'
,next_date => to_date('25.01.2008 09:28:08','dd/mm/yyyy hh24:mi:ss')
,interval => 'sysdate+(5/1440)'
,no_parse => TRUE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
END;
/
commit;
The problem is it does not work in five minutes.
I am using 10 g by the way, 10.1.0.3
What can i do where can i check? any suggestions?