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

Filed under:
|
|

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

Related posts about plsql

Related posts about plsqldeveloper