oracle job执行失败,如何查询出错信息
oracle job未执行我的存储过程。job 代码为
variable job2 number ; begin
dbms_job.submit(:job2,'createlogs_time;',sysdate,'sysdate+3/1440');
end ;
存储过程代码为
create or replace procedure createlogs_timeAuthid Current_Userastabname varchar(200);beginselect 'ex_log' || to_char(sysdate, 'yyyymmdd') into tabname from dual;--create table tabname as select * from tbl_programme where 1 != 1;execute immediate 'create table ' || tabname ||' tablespace manage as select * from TMON_MONITOR_LOG_EXCLOG where 1 != 1';
commit;end;这是一个测试的,oracle job未执行我的存储过程。
oracle job未执行我的存储过程。job 代码为
variable job2 number ; begin
dbms_job.submit(:job2,'createlogs_time;',sysdate,'sysdate+3/1440');
end ;
存储过程代码为
create or replace procedure createlogs_timeAuthid Current_Userastabname varchar(200);beginselect 'ex_log' || to_char(sysdate, 'yyyymmdd') into tabname from dual;--create table tabname as select * from tbl_programme where 1 != 1;execute immediate 'create table ' || tabname ||' tablespace manage as select * from TMON_MONITOR_LOG_EXCLOG where 1 != 1';
commit;end;这是一个测试的,oracle job未执行我的存储过程。
SQL> show parameter job
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 10
然后,你上面那个pl/sql块,没有commit,只有commit后job才会运行