Eason [資料科學//Python學習/資料庫] & [拍片&剪片]

select * from testt;

BEGIN  --制訂方案
DBMS_SCHEDULER.CREATE_PROGRAM (
program_name => 'insertdata',
program_action => 'insert into testt values(3);',
program_type => 'PLSQL_BLOCK',
enabled => TRUE);
END;
/

BEGIN  --安排時間
DBMS_SCHEDULER.CREATE_SCHEDULE (
schedule_name => 'MySchedule',
start_date => SYSDATE,
repeat_interval => 'FREQ=SECONDLY; INTERVAL=1',
comments => 'Every 1 sec');
END;
/

BEGIN  --创建job，按照指定的schedule，执行program
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'ExecCmd',
program_name => 'insertdata',
schedule_name => 'MySchedule',
enabled => true);
END;
/

exec dbms_scheduler.disable('ExecCmd');
exec dbms_scheduler.enable('ExecCmd');

參考:http://blog.csdn.net/tianlesoftware/article/details/4715218