use this script:declare
-- Local variables here
v_jobnum number;
begin
-- Test statements here
dbms_job.submit(v_jobnum,'your_procedure;',sysdate,'last_day(sysdate)+1');
--dbms_output.put_line('job '||v_jobnum||' has been submitted.');
--dbms_job.run(v_jobnum,TRUE);
--dbms_job.run(29,TRUE);
--DBMS_JOB.REMOVE(6);
COMMIT;
end;
-- Local variables here
v_jobnum number;
begin
-- Test statements here
dbms_job.submit(v_jobnum,'your_procedure;',sysdate,'last_day(sysdate)+1');
--dbms_output.put_line('job '||v_jobnum||' has been submitted.');
--dbms_job.run(v_jobnum,TRUE);
--dbms_job.run(29,TRUE);
--DBMS_JOB.REMOVE(6);
COMMIT;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货