Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: dbms_job not Working
发件人: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 代
表 GovindanK
发送时间: 2007年3月9日 13:26
收件人: sbootsma_at_georgebrown.ca; oracle-l_at_freelists.org
主题: Re: dbms_job not Working
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)' );
,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_at_georgebrown.ca> said:
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Mar 09 2007 - 01:32:42 CST
![]() |
![]() |