JOB no Oracle 9i

[Leonardo LitzParticipante]

Olá Evloki.

Tira o exec da chamada e os : da variavel V_JOB.


DECLARE
V_JOB NUMBER;
BEGIN
dbms_job.submit(V_JOB, 'P_SATUS_HIST', SYSDATE, 'SYSDATE +1');
commit;
end;

Vlw Leonardo Litz