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 vote365 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
0 vote328 views1 answer
Postgres select except
SQL
0 vote354 views1 answer
No query unable to fetch row sqlite
SQL
0 vote372 views1 answer
Show all sequences postgres
SQL
11 votes381 views2 answers
Oracle saurce code
SQL
0 vote349 views1 answer
ORA-00942
SQL
0 vote345 views1 answer
List all functions and procedures in postgres query
SQL
0 vote371 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
2 votes355 views1 answer
How to delete all duplicate items in mysql
SQL
13 votes356 views2 answers
Sql online compiler
SQL