create table times(cl date); alter session set nls_date_format='dd-mm-yy hh24:mi:ss';declare begin dbms_scheduler.create_job( job_name=>'savedate', job_type=>'plsql_block', job_action=>'insert into times values(sysdate);', start_date=>sysdate, repert_interval=>'freq=minutely;interval=1', enabled=>true, auto_drop=>false ); end给你一个create job实例。不过需要用户有create job的权限啊!
执行内容:Update repository Set status = '0'
create table times(cl date);
alter session set nls_date_format='dd-mm-yy hh24:mi:ss';declare
begin
dbms_scheduler.create_job(
job_name=>'savedate',
job_type=>'plsql_block',
job_action=>'insert into times values(sysdate);',
start_date=>sysdate,
repert_interval=>'freq=minutely;interval=1',
enabled=>true,
auto_drop=>false
);
end给你一个create job实例。不过需要用户有create job的权限啊!
参考下:
variable job1 number;
begin
sys.dbms_job.submit(job => :job1,
what => 'begin CDM_AutoDeleteMRData_PRC;end;',
next_date => to_date('15-04-2009 14:03:25', 'dd-mm-yyyy hh24:mi:ss'),
interval => 'to_date(to_char(sysdate, ''yyyy-mm-dd''), ''yyyy-mm-dd HH24:MI:SS'')+1+1/24');
commit;
end;
/