oracle
job 프로시저 수행
studyhard24
2017. 9. 27. 16:26
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;
/