declare

     x number;

begin

 dbms_job.submit

(

job =>x

,what =>'t_owner.p_test_01;'

,next_date=>sysdate

,interval =>'trunc(sysdate)+1'

,no_parse => false

);

commit;

dbms_output.put_line('job number is:'||to_char(x));

end;

/


+ Recent posts