create or replace procedure P_test
is
begin
dbms_output.put_line('这是系统测试');
end P_test;
declare jobno number;
begin
dbms_job.submit(jobno,'P_test;',trunc(last_day(sysdate)+1),'trunc(last_day(add_months(sysdate,1))+1)');
commit;
end;
create or replace procedure P_test
is
begin
dbms_output.put_line('这是系统测试');
end P_test;
declare jobno number;
begin
dbms_job.submit(jobno,'P_test;',trunc(last_day(sysdate)+1),'trunc(last_day(add_months(sysdate,1))+1)');
commit;
end;