job test를 수행합니다.
해당 job은
create sequence seq_job_seq1;
create table job_test01
(no number,
name varchar(5)
)
create or replace procedure insert_job_test01
is
begin
insert into scott.job_test01
values(seq_job_seq1.nextval, dbms_random.string('a',3));
end;
/
begin
dbms_job.submit
(
:jno,
'scott.insert_job_test01;',
sysdate,
'sysdate + 1/24/60',
false);
end
/