 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
