------建立任务
begin
dbms_scheduler.create_job (job_name => '周期费用',
job_type => 'STORED_PROCEDURE',
job_action => 'SEST_CycleFeeCalc',
start_date => TRUNC(sysdate+1),
end_date => add_months(sysdate,120),
repeat_interval => 'FREQ=DAILY;INTERVAL=1',
enabled => true,
comments => '定时执行计划任务'
);
end;
/
-----删除任务
begin
dbms_scheduler.drop_job(job_name => '周期计算库存费用');
end;
/
------查询任务
select * from user_SCHEDULER_JOBS