Trying to make a job to be executed after each 1 minute,but its not working?

Vineet picture Vineet · May 2, 2010 · Viewed 18.1k times · Source

I have made this job,that should be executed in an interval of 1 minute,but it's 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;

Answer

Martin Milan picture Martin Milan · May 2, 2010

Try next_date = sysdate + (1/24/60) and interval = (1/24/60)...