我设法从DBMS_SCHEDULER运行一个工作 . 但是从昨天开始运行,我无法阻止它 . 这份工作的代码是:
begin
sys.dbms_scheduler.create_job(job_name => 'FTREC.EXE_1',
job_type => 'EXECUTABLE',
job_action => 'C:\Users\WWLSERVER\Desktop\test.bat',
start_date => to_date(null),
repeat_interval => '',
end_date => to_date(null),
job_class => 'MY_JOB_CLASS',
enabled => false,
auto_drop => false,
comments => '');
end;
我试图停止工作/放弃它,但没有运气 .
当我跑:
begin
dbms_scheduler.stop_job('FTREC.EXE_1',true);
end;
我没有错,但是
SELECT * FROM USER_SCHEDULER_RUNNING_JOBS;
如果我尝试放弃作业,则返回EXE_1
begin
dbms_scheduler.drop_job('FTREC.EXE_1',true);
end;
我收到此错误:
ORA-27478: job "FTREC.EXE_1" is running
ORA-06512: at "SYS.DBMS_ISCHED", line 213
ORA-06512: at "SYS.DBMS_SCHEDULER", line 657
ORA-06512: at line 2
我重新启动了服务器,但我没有运气 . 我有什么想法可以阻止/放弃这份工作吗?