BEGIN
DBMS_SCHEDULER.create_program (
program_name => 'test_plsql2',
program_type => 'PLSQL_BLOCK',
program_action => 'BEGIN create table ccc as select * from aaa; END;',
enabled => TRUE,
comments => 'create using a PL/SQL block.');
END;
/
DBMS_SCHEDULER.create_job (
job_name => 'test_prog_job_definition',
program_name => 'test_plsql2',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=hourly; byminute=0',
end_date => NULL,
enabled => TRUE,
comments => 'Job defined by existing program and inline schedule.');
BEGIN
DBMS_SCHEDULER.run_job (job_name => 'test_prog_job_definition',use_current_session => FALSE);
END;
执行完毕以后,我查看了
dba_scheduler_job_log 表中仍然为失败状态 operation为run status为:RUN FAILED
请大家帮我看一下啊!
DBMS_SCHEDULER.create_program (
program_name => 'test_plsql2',
program_type => 'PLSQL_BLOCK',
program_action => 'BEGIN create table ccc as select * from aaa; END;',
enabled => TRUE,
comments => 'create using a PL/SQL block.');
END;
/
DBMS_SCHEDULER.create_job (
job_name => 'test_prog_job_definition',
program_name => 'test_plsql2',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=hourly; byminute=0',
end_date => NULL,
enabled => TRUE,
comments => 'Job defined by existing program and inline schedule.');
BEGIN
DBMS_SCHEDULER.run_job (job_name => 'test_prog_job_definition',use_current_session => FALSE);
END;
执行完毕以后,我查看了
dba_scheduler_job_log 表中仍然为失败状态 operation为run status为:RUN FAILED
请大家帮我看一下啊!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货