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;
Try next_date = sysdate + (1/24/60) and interval = (1/24/60)...