Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: dbms_job not Working

Re: dbms_job not Working

From: jametong <jametong_at_gmail.com>
Date: Fri, 9 Mar 2007 15:32:42 +0800
Message-ID: <45f10da5.360cdf47.26d4.5a44@mx.google.com>

  1. Have you prperly set your job_queue_processes
  2. What is the alert log, job process trace info for the job.
  3. how about add some log information to a temp table to trace it.

发件人: 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)'
                    );

  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 Fri Mar 09 2007 - 01:32:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US