Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> DBMS_JOBs don't start
Hi,
I want to execute a stored procedure periodicly using the DBMS_JOB package. But the job doesn't run after submitting it with DBMS_JOB.SUBMIT. Only when I run it once manually with DBMS_JOB.RUN it continues to run at the specified intervall. I tried this with Oracle 7.3.4 under NT.
Any idea?
Thanks
Helmut
Example:
execute dbms_job.submit(:n, 'job1;', sysdate+1/(60*24), 'sysdate+1/(60*24)');
Waiting some minutes...
select last_sec, this_sec, next_sec, interval from user_jobs;
LAST_SEC THIS_SEC NEXT_SEC INTERVAL
-------- -------- -------- -----------------
22:13:25 sysdate+1/(60*24)
execute dbms_job.run(25);
select last_sec, this_sec, next_sec, interval from user_jobs;
LAST_SEC THIS_SEC NEXT_SEC INTERVAL
-------- -------- -------- -----------------
22:24:09 22:25:09 sysdate+1/(60*24)
select last_sec, this_sec, next_sec, interval from user_jobs;
LAST_SEC THIS_SEC NEXT_SEC INTERVAL
-------- -------- -------- ---------------- 22:25:30 22:26:30 sysdate+1/(60*24)Received on Wed May 06 1998 - 15:38:35 CDT
![]() |
![]() |