ORACLE删除job报错ORA-27478

        若删除job报错

ORA-27478: job "" is running
ORA-06512: at "SYS.DBMS_ISCHED", line 182
ORA-06512: at "SYS.DBMS_SCHEDULER", line 615
ORA-06512: at line 1

        查看job是否还在运行

select * from dba_scheduler_running_jobs where job_name='job_name';　　

        先stop再删就可以了

BEGIN
  dbms_scheduler.stop_job(JOB_NAME => 'job_name');
END;