Scheduler Jobs
梁鸣
begin
dbms_scheduler.create_job(
job_name =>'job2',
job_type =>'PLSQL_BLOCK',
job_action =>'insert into xx values(3);',
start_date =>SYSDATE,
repeat_interval =>'FREQ=DAILY ;INTERVAL=1');
end;
/
dbms_scheduler.create_job(
job_name =>'job2',
job_type =>'PLSQL_BLOCK',
job_action =>'insert into xx values(3);',
start_date =>SYSDATE,
repeat_interval =>'FREQ=DAILY ;INTERVAL=1');
end;
/
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25198367/viewspace-704246/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/25198367/viewspace-704246/
类似资料：