Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Urgent! on dbms_job
Hello all,
The configuration: oracle 8.1.5 on NT4 or NT2000
the following parameters are set in init.ora
job_queue_interval = 20 (20 seconds?)
job_queue_processes = 1
The problem is that I am not able to run dbms_job.submit
Even with a simple tes tit does not work:
I created the following table:
testh (name varchar2(20))
insert into testh values('xxxx');
and procedure:
create or replace procedure putname(p_name in varchar2)
as
begin
update testh
set name=p_name;
end;
/
in sqlplus
var x number;
(as a dba !)
sql>exec dbms_job.submit(:x,'putname(''helpppppp'') ; commit ; ',
sysdate+1/1440);
plssql succesfully completed
Just wait and wait and wait....
select job from user_jobs just gave the same jobnr. as the value of x
(print x)
select * from testh just give 'xxxx'....
Only when i do dbms.run(:x) it will update the table.
I have looked in bdump but no trace file of snp0.trc of something alike.
I have also look in the alertlog and also no indication
What did I do wrong?????? Do I missed some points here?
Glad to hear if somebody else has encounters the same problem or has a solution for me.
henk
PS: This my second post for the same problem Received on Sun Sep 17 2000 - 17:14:56 CDT