| DBMS_JOB : every minute <99.99% "do nothing"> Job disappears [message #205546]
||Sat, 25 November 2006 17:40
Registered: November 2006
Location: Banking Industry, Germany
My DB-Job disappears. It should run every minute :
job => myjob
interval => 'sysdate + (1/1440)'
what => 'begin myproc; end;'
myproc is a procedure that looks if a certain system state is set and then starts running. If the system state is not set, the procedure quits.
procedure myproc is
select state into l_state
where rownum <= 1;
if l_state = 'RESYNCHRONIZE' then
procedure pr_resynchronize is
... business logic ...
The used hardware is fast, very fast.
Oberservations have shown that once installed, the job keeps in the job-queue for undefined times: one minute, one day, two hours etc.
It drives me creazy. No dumps. Nothing.
Note: we scedule about 5.000-10.000 jobs per day. But this particulare one simply disappears.
Has anybody an advice or idea ?
Thanx in advance