查询所有调度作业
select * from ALL_SCHEDULER_JOBS;
查询当前用户调度作业
select * from USER_SCHEDULER_JOBS;
创建调度作业两种情况
(1)
begin
sys.dbms_scheduler.create_job(job_name => 'sa.SCHED_JOB_YN',
job_type => 'PLSQL_BLOCK',
job_action => '/* 更改字段值 */
UPDATE aa a
SET A.CHECK = ''N''
WHERE CHECK=''Y'';
COMMIT;',
start_date => to_date('26-04-2021 22:30:00', 'dd-mm-yyyy hh24:mi:ss'),
repeat_interval => 'Freq=DAILY;Interval=1',
end_date => to_date(null),
job_class => 'DEFAULT_JOB_CLASS',
enabled => true,
auto_drop => false,
comments => '');
end;
/
(2)
begin
sys.dbms_scheduler.create_job(job_name => 'sa.SCH_JOB_TMP',
job_type => 'STORED_PROCEDURE',
job_action => 'sa.pro_tmp',--存储过程名称
start_date => to_date('01-04-2021 05:00:00', 'dd-mm-yyyy hh24:mi:ss'),
repeat_interval => 'Freq=DAILY;Interval=1',
end_date => to_date(null),
job_class => 'DEFAULT_JOB_CLASS',
enabled => true,
auto_drop => false,
comments => '');
end;
/