dbms_job(is wrong and your code would fail. I'll assume it is a typo and real code has:
dbms_job.submit(Then, what happens if you log in as same user who issued the above and run:
begin qc2.start_all(sysdate-1); end;Does it insert a row you were looking for?
set serveroutput on; declare job_no number; begin dbms_job.submit( job => job_no, what => 'begin qc2.start_all(sysdate-1); end;', next_date => trunc(sysdate)+26/24, interval => 'TRUNC(SYSDATE) + 24/26' ); end; commit;
and verify if row gets inserted. If it doesn't get inserted we will know it has nothing to do with dbms_job but with your qc2.start_all procedure. If it does, we need to investigate more.
begin qc2.start_all(sysdate-1); end; /