dbms_job.submit not running automatically
614945Jan 24 2011 — edited Jan 24 2011Hi,
I have created a code to run a job every minute through dbms_job.submit but it appears that it is not working.
SQL >var v number
SQL> begin
2 dbms_job.submit(:v,'BO.TEST_SCHEDULE ( 50, ''test'');',sysdate,'(sysdate+1/24/60)');
3 commit;
4 end;
5 /
I have to manually execute this by giving this command :- exec dbms_job.run('301')
Please suggest how to proceed.
Thanks