This content has been marked as final. Show 7 replies
Here is an example , Job statspack.snap; will execute every 15 min
BEGIN DECLARE v_JobNum NUMBER; BEGIN DBMS_JOB.SUBMIT(v_JobNum,'statspack.snap;',sysdate,'SYSDATE+(15/(24*60))'); commit; end; END; /
pls help me out......
how to create the jobs in oracle and how to execute it within every 15 min ....
give me examples .....
A good insight
the link posted By ed.
i trying to execute same things but its not executed concurrently ......
only execute directly ......
If it got successfully executed on single execution then check below if job is visible
select job,what,INTERVAL,NEXT_DATE from dba_jobs;
Job will run automatically every 15 min
and also check