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 vote262 views1 answer
Wherein mysql
SQL
0 vote233 views1 answer
Alter domain sql
SQL
9 votes226 views3 answers
Mysql run sql file
SQL
2 votes202 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
0 vote222 views1 answer
Oracle concat datetime
SQL
2 votes366 views1 answer
How to create sql database
SQL
0 vote198 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote202 views1 answer
Sauvegarde complète my sql
SQL
0 vote199 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote199 views1 answer
Postgresql create table many-to-many
SQL