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

-2 votes188 views1 answer
No module named '_sqlite3
SQL
4 votes163 views3 answers
Oracle sql first day of quarter
SQL
0 vote170 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote187 views1 answer
Sql drop default
SQL
6 votes192 views2 answers
Difference between join vs union
SQL
2 votes173 views1 answer
Mysql last 7 days including today
SQL
1 vote227 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
0 vote289 views1 answer
Sql insert exemplo
SQL
0 vote239 views1 answer
Mysql multiple group by
SQL
0 vote194 views1 answer
Where field is null sql knex
SQL