Re: dbms_job not Working

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Fri, 9 Mar 2007 05:25:43 UT
Message-Id: <1173417943.32254.1178547709@webmail.messagingengine.com>

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_at_georgebrown.ca> said:

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 08 2007 - 23:25:43 CST