Re: dbms_job not Working
- From: "GovindanK" <gkatteri@xxxxxxxxxxx>
- To: sbootsma@xxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 08 Mar 2007 21:25:43 -0800
Alexander has given some inputs. Also what version? Are you on Solaris 9.2.0.1;
It had a bug ; The dbms_job used stop for no apparent reason (though in your
case it does not kick in at the first place). We had to move to 9.2.06.
Here is a sample
set serveroutput on size 100000;
declare
l_job number;
begin
begin
dbms_job.submit(job => l_job
,what => 'my_pack.procedure;'
,next_date => sysdate
,interval => 'sysdate+1/(60*24)'
);
end;
commit;
dbms_output.put_line('Job started = '|| l_job);
end;
/
set linesize 132;
column what format A50 wrap;
SELECT job
,what
,to_char(last_date, 'DD-MON-YY') l1
,last_sec l2
,to_char(next_date, 'DD-MON-YY') n1
,next_sec n2
,failures
,broken
FROM user_jobs
ORDER BY next_date DESC
,next_sec DESC
/
HTH
GovindanK
On Thu, 8 Mar 2007 17:17:50 -0500, "Sam Bootsma" <sbootsma@xxxxxxxxxxxxxx> said:
Other related posts:
