Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Oracle Job Queue not running
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
![]() |
![]() |