ORA-27478: job ““ is running

        若删除job报错

1 2 3 4

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是否还在运行

1	select * from dba_scheduler_running_jobs where job_name='job_name';

        先停止再删就可以了

1 2 3

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

分类: oracle