How to Stop Running Job

[mtdeep2002]

إزاي ممكن نوقف وظيفة شغالة بدون عمل إعادة تشغيل الجهاز

[motasem]

ماذا تقصد بوظيفة شغالة ( running job) هل تقصد oracle running job أم ماذا

[أسامة موسى]

الاخ الكريم
ممكن عمل توقيف من خلال ENTERPRISE MANAGER
حيث تعمل Kill Session من instance للمستخدم وتجده عادة active
للوظيفة فتتوقف وبذلك تتلاشى عمل عادة تشغيل

[uiuc85]

Use the following command for the job that you have to deal with.

SQL> EXEC DBMS_JOB.BROKEN(job#,TRUE);

All this command does is mark the job so that if we get it to stop, it won't start again



Since the job is still running and it isn't going to end soon, you will need to kill the Oracle session that is executing the job. Use the following command for to kill the job.

ALTER SYSTEM KILL SESSION 'sid,serial#';

SQL> ALTER SYSTEM SET job_queue_processes = 0;

ALTER SYSTEM SET job_queue_processes = original_value;



Hope this helps

Ammar Sajdi
www.e-ammar.com
Amman Jordan

[mtdeep2002]

these commands can't execute when the job is running
it can't break
and the session can't killed ever till the job stopped
i mean te job when run a procedure or function it can't stop or break till the pro. or fun. finish
and when restart the server the job 'll run again immediatelly after the database started.

[أسامة موسى]

ممكن ايقاف الوظيفة عن طريق
control panel
administrative tools
service
وقم بايقاف الخاصية
التي تريد

[mohr_g]

Follow the below :

1- Find SID for running JOB :
select j.sid,
s.spid,
s.serial#,
j.log_user,
j.job,
j.broken,
j.failures,
j.last_date||':'||j.last_sec last_date,
j.this_date||':'||j.this_sec this_date,
j.next_date||':'||j.next_sec next_date,
j.next_date - j.last_date interval,
j.what
from (select djr.SID,
dj.LOG_USER, dj.JOB, dj.BROKEN, dj.FAILURES,
dj.LAST_DATE, dj.LAST_SEC, dj.THIS_DATE, dj.THIS_SEC,
dj.NEXT_DATE, dj.NEXT_SEC, dj.INTERVAL, dj.WHAT
from dba_jobs dj, dba_jobs_running djr
where dj.job = djr.job ) j,
(select p.spid, s.sid, s.serial#
from v$process p, v$session s
where p.addr = s.paddr ) s
where j.sid = s.sid;

2- Kill sesion
ALTER SYSTEM KILL SESSION ''sid,serial#'';
3-
a- On Unix
Kill -9 spid

b- On Windows
use Task Manager
end process (PID=spid)