Trying to make a job to be executed after each 1 minute,but its not working?
Posted
by Vineet
on Stack Overflow
See other posts from Stack Overflow
or by Vineet
Published on 2010-05-02T08:39:22Z
Indexed on
2010/05/02
8:47 UTC
Read the original article
Hit count: 153
I have made this job,that should be executed in an interval of 1 minute,but its not working .When i use execute dbms_job.run(2); it gets executed.printe is a procedure Please suggest!
BEGIN
DBMS_JOB.SUBMIT
(
job =>:job_no,
WHAT=>'printe;',--Procedure
next_date=>sysdate+1/24*60,
interval=>'sysdate+1/24*60'
);
commit;
END;
© Stack Overflow or respective owner