Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DBMS_JOBs don't start

DBMS_JOBs don't start

From: Helmut Swaczinna <swaczin_at_wmd.de>
Date: 6 May 1998 20:38:35 GMT
Message-ID: <6iqhob$m8b$1@ns2.dokumenta.de>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US