четверг, 14 ноября 2013 г.

Oracle остановить все job-ы в sheduler


если по босяцки:

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;
/