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

Home -> Community -> Usenet -> c.d.o.server -> Oracle Job Queue not running

Oracle Job Queue not running

From: <kmohanraj_at_gmail.com>
Date: 29 Jan 2007 02:50:01 -0800
Message-ID: <1170067801.608353.125380@h3g2000cwc.googlegroups.com>


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 ? Received on Mon Jan 29 2007 - 04:50:01 CST

Original text of this message

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