Re: dbms_job not Working

  • From: "jametong" <jametong@xxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 9 Mar 2007 15:32:42 +0800

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 代
表 GovindanK
发送时间: 2007年3月9日 13:26
收件人: sbootsma@xxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
主题: 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@xxxxxxxxxxxxxx> said:


Other related posts: