Hi

I need to schedule a procedure using dbms_job.

I created it using the following script.

declare
jobno number;
begin
dbms_job.submit(jobno,'SP_PRE;', sysdate+1/1400,'sysdate+1/1400');
commit;
end;

When I check the user_jobs, the next_date column shows the process is due to run in a minute but its not executing at all. Where us If I use DBMS_JOB.RUN(1), its executing the procedure SP_PRE.

In init.ora, I have the following setting

job_queue_processes = 4
job_queue_interval = 60

Any thoughts?

Thanks

Raj