Breaking News: Grepper is joining You.com. Read the official announcement!

oracle kill job by sid

VasteMonde answered on April 21, 2021 Popularity 8/10 Helpfulness 7/10

answer oracle kill job by sid

oracle kill job by sid

Comment

-- Get Job session IDs
SELECT jr.JOB, s.USERNAME, s.SID, s.SERIAL#, p.SPID, s.LOCKWAIT, s.LOGON_TIME
FROM DBA_JOBS_RUNNING jr, V$SESSION s, V$PROCESS p
WHERE jr.SID = s.SID AND s.PADDR = p.ADDR ORDER BY jr.JOB;
-- Or simply a session
SELECT SID, SERIAL#, STATUS, SERVER FROM V$SESSION WHERE USERNAME = '<username>';
-- Kill session with IDs and wait for rollback if any...
ALTER SYSTEM KILL SESSION 'SID,SERIAL#' IMMEDIATE;
-- To simply stop job without killing session:
BEGIN
    DBMS_SCHEDULER.STOP_JOB(JOB_NAME => 'scheme.job_name', FORCE => TRUE);
END;

Popularity 8/10 Helpfulness 7/10 Language sql

Source: Grepper

Tags: kill oracle session sid sql

Link to this answer
Share Copy Link

Contributed on Apr 21 2021

VasteMonde

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

oracle kill job by sid

Contents

More Related Answers

oracle kill job by sid

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.