1.-------------创建调度计划(schedule)
begin
DBMS_SCHEDULER.CREATE_SCHEDULE (
schedule_name => 'PRO_INFO_JOB_SCHEDULE ',
start_date => SYSDATE,
repeat_interval => 'FREQ=MINUTELY; INTERVAL=1',
comments => 'Every 2 HOURLY');
END;
2.-------------------创建程序,调度应该做什么事情(program)
BEGIN
DBMS_SCHEDULER.CREATE_PROGRAM (
program_name => 'PRO_INFO_JOB__PROGRAM',
program_action => 'PRO_INFO_JOB0711',
program_type => 'STORED_PROCEDURE',
enabled => TRUE);
END;
3.----------------创建作业(job)
job表示按照指定的schedule,执行指定program,完成用户指定的工作。
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'PRO_INFO_JOB_JOB',
program_name => 'PRO_INFO_JOB__PROGRAM',
schedule_name => 'PRO_INFO_JOB_SCHEDULE',
enabled => true);
END;
查询 schedules:
select * from user_scheduler_schedules;
删除
begin
DBMS_SCHEDULER.DROP_SCHEDULE('PRO_INFO_JOB_synchron');
end;
查询 programs:
select * from user_scheduler_programs;
end;
删除
begin
dbms_scheduler.drop_program('PRO_INFO_JOB__program');
end;
查询 job :
SELECT * FROM DBA_SCHEDULER_JOBS;
删除job
begin
DBMS_SCHEDULER.DROP_JOB(JOB_NAME => 'PRO_INFO_JOB_job');
end;
begin
DBMS_SCHEDULER.CREATE_SCHEDULE (
schedule_name => 'PRO_INFO_JOB_SCHEDULE ',
start_date => SYSDATE,
repeat_interval => 'FREQ=MINUTELY; INTERVAL=1',
comments => 'Every 2 HOURLY');
END;
GO
BEGIN
DBMS_SCHEDULER.CREATE_PROGRAM (
program_name => 'PRO_INFO_JOB__PROGRAM',
program_action => 'PRO_INFO_JOB0711',
program_type => 'STORED_PROCEDURE',
enabled => TRUE);
END;
GO
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'PRO_INFO_JOB_JOB',
program_name => 'PRO_INFO_JOB__PROGRAM',
schedule_name => 'PRO_INFO_JOB_SCHEDULE',
enabled => true);
END;
GO