oracle如何重建job,Oracle Job的批量删除与重建脚本

-- 批量删除job

declare

v_exist number(2); -- job是否存在

begin

for x in 1..8 LOOP

select count(1) into v_exist from user_scheduler_jobs WHERE job_name = ‘PROCESS_BILL_DATA_‘ || x ;

if v_exist > 0 then

dbms_scheduler.drop_job(job_name => ‘PROCESS_BILL_DATA_‘ || x,force => TRUE);

dbms_output.put_line(‘drop job :‘ || x );

end if;

end loop;

end;

/

-- 查看pl/sql output页签输出,显示日志，删除job的个数

-- 批量创建job 8个

declare

begin

for x in 1..8 LOOP

sys.dbms_scheduler.create_job(job_name => ‘PROCESS_BILL_DATA_‘ || x,

job_type => ‘PLSQL_BLOCK‘,

job_action => ‘begin process_bill_data(8,‘||(x-1)||‘,10000,500); end;‘,

start_date => to_date(‘06-08-2013 16:26:05‘, ‘dd-mm-yyyy hh24:mi:ss‘),

repeat_interval => ‘FREQ=MINUTELY;INTERVAL=1;‘,

end_date => to_date(null),

job_class => ‘DEFAULT_JOB_CLASS‘,

enabled => true,

auto_drop => true,

comments => ‘清单数据处理_‘||x);

dbms_output.put_line(‘create job :‘ || x );

end loop;

end;

/

Oracle Job的批量删除与重建脚本

标签：loop star interval force 清单 个数 ora 数据 obs

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉 本文系统来源：https://www.cnblogs.com/fubinhnust/p/9928642.html