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

1 vote262 views1 answer
Get table column names sql ssms
SQL
0 vote285 views2 answers
Disallowed function mysql to_date()
SQL
5 votes272 views1 answer
Get table columns from sql
SQL
8 votes263 views2 answers
Safe update mode in mysql
SQL
5 votes266 views4 answers
Change auto increment mysql
SQL
1 vote253 views1 answer
Oracle apex prevent initial load
SQL
0 vote275 views1 answer
Php mysqli install
SQL
0 vote260 views2 answers
Sql query for getting details by id
SQL
6 votes255 views2 answers
Database url postgres
SQL
1 vote254 views1 answer
Psql client write to bash variable
SQL