[Oracle] [DBA] kill job

參考來源

1. 確認該job目前是否有正在run

SELECT * FROM DBA_JOBS_RUNNING where job=44807673

2. 先把該job disabled(take offline)

begin
 dbms_job.broken(44807673,true);
end;

3. 立即砍掉該job

ALTER SYSTEM KILL SESSION '2060,44807673' immediate;  --參數'SID, JOB'