建一JOB,针对存储过程MYPROC,每天凌晨执行一次:
variable job0111 number;
BEGIN
DBMS_JOB.SUBMIT(:job0111,'MYPROC;',SYSDATE,'trunc(SYSDATE)+1');
COMMIT;
END;
/
手动运行job:
begin
dbms_job.run(:job0111);
end;
/
查job的id号:
select job,what from user_jobs;
job what
25 MYPROC
删除job
exec dbms_job.remove(:job0111)
or
exec dbms_job.remove(25)[@more@]
variable job0111 number;
BEGIN
DBMS_JOB.SUBMIT(:job0111,'MYPROC;',SYSDATE,'trunc(SYSDATE)+1');
COMMIT;
END;
/
手动运行job:
begin
dbms_job.run(:job0111);
end;
/
查job的id号:
select job,what from user_jobs;
job what
25 MYPROC
删除job
exec dbms_job.remove(:job0111)
or
exec dbms_job.remove(25)[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9721529/viewspace-997122/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9721529/viewspace-997122/