Re: Oracle Job Queue not running

On 29 Jan 2007 02:50:01 -0800, kmohanraj_at_gmail.com wrote:

>Hi,
>I have submitted a job to the oracle job queue using this command
>
>DECLARE jobno number;
>BEGIN
> DBMS_JOB.SUBMIT(jobno,
> 'delete from session_data_store where
>to_number(time_diff(created_on,sysdate))>300;',
> TO_DATE('Monday, January 29, 2007 04 16 03 PM', 'DAY, MONTH DD,
>YYYY HH:MI:SS AM'),
> 'SYSDATE+1',
> TRUE);
>COMMIT;
>END;
>/
>
>When i try the below command the job is running fine and the next_date
>and next_sec is set
>begin
> dbms_job.run(14);
>end;
>/
>
>The problem is the job is not triggered automatically at the
>particular time. It is only getting executed when I execute
>dbms_job.run command.
>Is there any thing i left undone ?

What Sybrand said..
Also, make sure your commit the job (looks like you do)

          make sure youd database has been bounced at least once since initial build (that one bit me a few times) .......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Thu Feb 01 2007 - 03:16:10 CST