Oracle kill job by sid

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

Similar codes

0 vote112 views1 answer
Ffeathers express mysql application users login
SQL
11 votes103 views2 answers
Having keyword sql
SQL
0 vote100 views1 answer
Mysql grant all on all databases
SQL
1 vote93 views1 answer
Foreign key constraint in ms sql
SQL
6 votes98 views2 answers
How to get yesterday date in mysql
SQL
0 vote110 views1 answer
Two inner joins sql
SQL
0 vote105 views1 answer
T sql cursor tr
SQL
0 vote120 views1 answer
Postgres list all triggers
SQL
0 vote99 views1 answer
How to Remove milliseconds from Date time
SQL
5 votes104 views1 answer
Oracle generate list of dates in between a date range
SQL