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

13 votes310 views5 answers
Oracle list tables
SQL
3 votes385 views2 answers
Update part of a string in mysql
SQL
1 vote391 views1 answer
Sql first day quarter
SQL
0 vote342 views1 answer
What is between keyword used for
SQL
0 vote328 views1 answer
Codeigniter dbforge add index
SQL
0 vote367 views1 answer
Create synonym for dblink in oracle
SQL
6 votes319 views1 answer
Rank function in oracle with example
SQL
2 votes360 views1 answer
Oracle to_char number format percentage
SQL
0 vote319 views1 answer
Replace null value within column mysql
SQL
4 votes320 views2 answers
DB::transaction
SQL