если по босяцки:
declare
c_job_name varchar2(40);
c_job_ownr varchar2(40);
cursor c_jobs Is
SELECT JOB_NAME,OWNER from ALL_SCHEDULER_JOBS
where JOB_NAME not in ('PURGE_LOG', 'ORA$AUTOTASK_CLEAN') and ENABLED = 'TRUE';
Begin
dbms_output.enable ;
OPEN c_jobs;
Loop
FETCH c_jobs into c_job_name, c_job_ownr;
EXIT WHEN c_jobs%NOTFOUND;
dbms_output.put_line(c_job_ownr||'.'||c_job_name);
--DBMS_SCHEDULER.stop_job(Name => c_job_ownr||'.'||c_job_name, FORCE => TRUE);
DBMS_SCHEDULER.DISABLE(Name => c_job_ownr||'.'||c_job_name );
End Loop;
close c_jobs;
END;
/
Комментариев нет:
Отправить комментарий