1.运行 create_program需要什么权限 ?
要保证create_program能够顺利执行,你同样需要CREATE JOB这个系统权限. 如果一个用户拥有了create any job这个权限,它就可以创建属主为任何用户的程序(SYS用户除外)
2.創建一個job
BEGIN
DBMS_SCHEDULER.CREATE_JOB
(
job_name => 'CATCH_LEANEMP_TEMP_TB'
,start_date => TO_TIMESTAMP_TZ('2009/12/16 15:45:00.000000 +08:00','yyyy/mm/dd hh24:mi:ss.ff tzh:tzm')
,repeat_interval => 'FREQ=DAILY;BYHOUR=8,9;BYMINUTE=10,55;BYSECOND=0'
,end_date => NULL
,job_type => 'PLSQL_BLOCK'
,job_action => 'BEGIN
PKG_WQY_TEMP.P_LEAN_EMP_TEMPTABLE(''參數'');
END;'
,comments => '¨C¤Ñ8:10,8:55,9:10,9:55°õ¦æ'
);
END;
3.激活jobs
begin
dbms_scheduler.enable('CATCH_LEANEMP_TEMP_TB');
end;
4.執行jobs
begin
dbms_scheduler.run_job('CATCH_LEANEMP_TEMP_TB');
end;
5.查詢用戶的jobs
select JOB_NAME,JOB_TYPE,JOB_ACTION,REPEAT_INTERVAL,RUN_COUNT,STATE,COMMENTS from user_scheduler_jobs ;