Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Job doesnt work in five minutes intervals

451321Jan 25 2008 — edited Jan 28 2008
Hi,

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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 25 2008
Added on Jan 25 2008
4 comments
535 views