1、查看定时任务情况
select owner,job_name,job_type,job_action,comments,enabled,to_char(last_start_date,‘yyyy-mm-dd hh24:mi:ss’),to_char(next_run_date,‘yyyy-mm-dd hh24:mi:ss’) from dba_scheduler_jobs;

需要禁用定时任务GLOGOWNER.BUSINESS_DATA_PURGE

2、禁用任务提示该任务在运行
begin
dbms_scheduler.disable(‘GLOGOWNER.BUSINESS_DATA_PURGE’);
end;
/

3、停止任务后再次禁用提示任务不存在
begin
DBMS_SCHEDULER.stop_job(‘GLOGOWNER.BUSINESS_DATA_PURGE’);
end;
/

begin
dbms_scheduler.disable(‘GLOGOWNER.BUSINESS_DATA_PURGE’);
end;
/

4、查看定时任务
select owner,job_name,job_type,job_action,comments,enabled,to_char(last_start_date,‘yyyy-mm-dd hh24:mi:ss’),to_char(next_run_date,‘yyyy-mm-dd hh24:mi:ss’) from dba_scheduler_jobs;