dbms_jobs not running immediately

[mike2000]

I have the below job and it should run immediately and schedule to be run at 9:00pm every night, how come it's not running immediately????




var x number
begin
dbms_job.submit(:x, ‘test;', TRUNC(sysdate)+21/24, 'TRUNC(sysdate)+1+21/24');
commit;
end;
/

[jovery]

Currently your job is set to run at 9pm today then at 9pm every day thereafter. I think you need something like this:

var x number
begin
dbms_job.submit(:x, ‘test;', sysdate, 'TRUNC(sysdate)+1+21/24');
commit;
end;
/

Regards

[marist89]

Also, make sure you have enough JOB_QUEUE_PROCESSES setup.