--创建job时如果遇到权限不够ORA-27486 ,需要给SIEBEL用户赋予下权限
sqlplus / as sysdba
grant create job to SIEBEL;
--创建job
job_type => 'STORED_PROCEDURE',
job_action => 'hok2',
start_date => sysdate,
repeat_interval => 'trunc(sysdate, ''HH24'') + 1/24',
auto_drop => false,
enabled => false);
exec dbms_scheduler.enable('myjob');