Home » RDBMS Server » Server Administration » DBMS_JOB : every minute <99.99% "do nothing"> Job disappears
icon5.gif  DBMS_JOB : every minute <99.99% "do nothing"> Job disappears [message #205546] Sat, 25 November 2006 17:40
Messages: 4
Registered: November 2006
Location: Banking Industry, Germany
Junior Member

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
l_state system_state.state%type;
select state into l_state
from system_state
where rownum <= 1;
if l_state = 'RESYNCHRONIZE' then
end myproc;

procedure pr_resynchronize is
... business logic ...
end pr_resynchronize;

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
Previous Topic: Problem in deallocating unused space within space
Next Topic: Starting Week from Saturday
Goto Forum:

Current Time: Mon Aug 21 10:46:35 CDT 2017

Total time taken to generate the page: 0.01286 seconds