ORACLE 停止运行一个job

今天有厂家说他们想停止运行一个job，发现停不下来，让我们帮忙

1）查看现在正在运行的job

SQL>  select OWNER,JOB_NAME,SESSION_ID from dba_scheduler_running_jobs;

OWNER                          JOB_NAME                       SESSION_ID

------------------------------ ------------------------------ ----------

DPPS_PROD                      JOB_DPPS_SYNC_INSIDE                 1132

2）通过SID和SERIAL#确定会话

SQL>  select SID,SERIAL# from v$session where sid='1132';

       SID    SERIAL#

---------- ----------

      1132       6861

3）杀掉会话

SQL> alter system kill session '1132,6861' immediate;

System altered.

4）确认删除

SQL>  select OWNER,JOB_NAME,SESSION_ID from dba_scheduler_running_jobs;

no rows selected