Re: Oracle Job Queue not running

On Jan 29, 11:50 am, kmohan..._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 ?

Please check the value of the parameter job_queue_processes. It should be > 0 for the facility to work.

--
Sybrand Bakker
Senior Oracle DBA