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
oranje66
Messages: 4
Registered: November 2006
Location: Banking Industry, Germany
Junior Member
Hello,

My DB-Job disappears. It should run every minute :
dbms_job.submit(
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;
begin
select state into l_state
from system_state
where rownum <= 1;
if l_state = 'RESYNCHRONIZE' then
pr_resynchronize;
end;
end myproc;

procedure pr_resynchronize is
...
begin
... 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: Table with a retention period
Next Topic: Starting Week from Saturday
Goto Forum:
  


Current Time: Sat Dec 10 20:18:09 CST 2016

Total time taken to generate the page: 0.08501 seconds