Dbms_scheduler stop job

Dbms_scheduler drop_job

BEGIN
  dbms_scheduler.drop_job(job_name => 'MY_OWNER.MY_JOB');
END;

Dbms_scheduler 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

4 votes298 views2 answers
Sql offset
SQL
5 votes299 views2 answers
Mysql create database charset utf8mb4
SQL
8 votes304 views2 answers
Replace string value in sql
SQL
17 votes344 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote305 views1 answer
Ansi sql count duplicate rows
SQL
1 vote242 views1 answer
Ms sql how to see active job current run time
SQL
12 votes290 views2 answers
Delete all entries postgres
SQL
10 votes290 views5 answers
Between keyword in sql
SQL
1 vote295 views1 answer
Where to locate set password for mysql
SQL
7 votes332 views1 answer
Show line number in sql server
SQL