Oracle stop job

-- To simply stop job without killing session:
BEGIN
    DBMS_SCHEDULER.STOP_JOB(JOB_NAME => 'scheme.job_name', FORCE => TRUE);
END;
-- Killing job's session: first 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;
-- Kill session with IDs and wait for rollback if any...
ALTER SYSTEM KILL SESSION 'SID,SERIAL#' IMMEDIATE;

Similar codes

1 vote253 views2 answers
Mysql SELECT
SQL
5 votes299 views2 answers
Oracle find all tables with column name
SQL
0 vote288 views1 answer
Oracle table free space
SQL
0 vote280 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote299 views2 answers
Plpgsql
SQL
16 votes264 views3 answers
Order by sql query
SQL
0 vote273 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote283 views1 answer
Sqlcmd no headers
SQL
1 vote295 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote295 views1 answer
Delete duplicate rows
SQL