Apache:
请Oracle牛帮忙看看,如下job,是否有可能一天执行多次
[阅读: 263] 2011-04-01 10:58:07
begin
sys.dbms_job.submit(job => :job,
what => \'declare
v_result number;
begin
v_result := KIS_MEMBER_GROWTH.DAILY_GROWTH_CONSUME_JOB (sysdate);
end;\',
next_date => to_date(\'02-04-2011\', \'dd-mm-yyyy\'),
interval => \'trunc(sysdate) + 1\');
commit;
end;