Die laufende Jobs abschiesse
Mit däm Skript cha me alli laufende Jobs us em Toad use kille
declare
type t_str_tab is table of varchar2(100) index by pls_integer;
l_cmd_tab t_str_tab;
l_job pls_integer;
begin
rollback;
select 'k.kill_session('|| ses.sid ||', '|| ses.serial# ||');'
bulk collect into l_cmd_tab
from dba_jobs job
,dba_jobs_running run
,v$session ses
where lower(job.what) like '%obj_bgp#.init%'
and run.job = job.job
and ses.sid = run.sid
order by job.what, job.job;
delete dba_jobs job
where lower(job.what) like '%obj_bgp#.init%';
for i in 1 .. l_cmd_tab.count loop
dbms_job.submit(l_job, l_cmd_tab(i));
end loop;
commit;
exception
when others then
rollback;
raise;
end;
/
