VARIABLE jobno number;
begin
DBMS_JOB.SUBMIT(:jobno,
'Procdemo;',
SYSDATE, 'trunc(SYSDATE) + 32/24');
commit;
end;
/
begin
DBMS_JOB.SUBMIT(:jobno,
'Procdemo;',
SYSDATE, 'trunc(SYSDATE) + 32/24');
commit;
end;
/
begin
sys.dbms_job.submit(job => :job,
what => 'SP_CLOSEWO;',
SYSDATE, 'trunc(SYSDATE) + 32/24');
commit;
end;
/
将EXEC proc_demo写到批处理文件里
at -f ./可执行脚本文件 8:00