Trying to make a job to be executed after each 1 minute,but its not working?
- by Vineet
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;