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: