详细:
http://topic.csdn.net/u/20091022/16/ceb1a717-5900-45ca-9907-54dd5185e6fd.html?seed=1524841382&r=60602540
SQL code
被连接到Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
被连接为koalaSQL>
SQL> variable job1 number;
SQL> begin
2 dbms_job.submit(:job1,'proc_auto_create_table;',to_date('2009-10-22 16:10:00','yyyy-mm-dd hh24:mi:ss'),
3 'trunc(add_months(sysdate,2),''mm'')-1/24');
4 end;
5 /PL/SQL 过程被成功完成
job1
---------
41SQL>
SQL> begin
2 dbms_job.run(:job1);
3 end;
4 /begin
dbms_job.run(:job1);
end;ORA-12011: 无法执行 1 作业
ORA-06512: 在 "SYS.DBMS_IJOB", line 406
ORA-06512: 在 "SYS.DBMS_JOB", line 272
ORA-06512: 在 line 2
job1
---------
41SQL> begin
2 dbms_job.run(41);
3 end;
4 /begin
dbms_job.run(41);
end;ORA-12011: 无法执行 1 作业
ORA-06512: 在 "SYS.DBMS_IJOB", line 406
ORA-06512: 在 "SYS.DBMS_JOB", line 272
ORA-06512: 在 line 2SQL> select * from all_jobs;JOB LOG_USER PRIV_USER SCHEMA_USER LAST_DATE LAST_SEC THIS_DATE THIS_SEC NEXT_DATE NEXT_SEC TOTAL_TIME BROKEN INTERVAL FAILURES WHAT NLS_ENV MISC_ENV INSTANCE
--- ------------------------------ ------------------------------ ------------------------------ ----------- ---------------- ----------- ---------------- ----------- ---------------- ---------- ------ -------------------------------------------------------------------------------- -------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------------------------------------------------------------- --------
41 KOALA KOALA KOALA 2009-10-22 23:39:53 0 N trunc(add_months(sysdate,2),'mm')-1/24 2 proc_auto_create_table; NLS_LANGUAGE='SIMPLIFIED CHINESE' NLS_TERRITORY='CHINA' NLS_CURRENCY='RMB' NLS_I 0102000200000000 0SQL>
http://topic.csdn.net/u/20091022/16/ceb1a717-5900-45ca-9907-54dd5185e6fd.html?seed=1524841382&r=60602540
SQL code
被连接到Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
被连接为koalaSQL>
SQL> variable job1 number;
SQL> begin
2 dbms_job.submit(:job1,'proc_auto_create_table;',to_date('2009-10-22 16:10:00','yyyy-mm-dd hh24:mi:ss'),
3 'trunc(add_months(sysdate,2),''mm'')-1/24');
4 end;
5 /PL/SQL 过程被成功完成
job1
---------
41SQL>
SQL> begin
2 dbms_job.run(:job1);
3 end;
4 /begin
dbms_job.run(:job1);
end;ORA-12011: 无法执行 1 作业
ORA-06512: 在 "SYS.DBMS_IJOB", line 406
ORA-06512: 在 "SYS.DBMS_JOB", line 272
ORA-06512: 在 line 2
job1
---------
41SQL> begin
2 dbms_job.run(41);
3 end;
4 /begin
dbms_job.run(41);
end;ORA-12011: 无法执行 1 作业
ORA-06512: 在 "SYS.DBMS_IJOB", line 406
ORA-06512: 在 "SYS.DBMS_JOB", line 272
ORA-06512: 在 line 2SQL> select * from all_jobs;JOB LOG_USER PRIV_USER SCHEMA_USER LAST_DATE LAST_SEC THIS_DATE THIS_SEC NEXT_DATE NEXT_SEC TOTAL_TIME BROKEN INTERVAL FAILURES WHAT NLS_ENV MISC_ENV INSTANCE
--- ------------------------------ ------------------------------ ------------------------------ ----------- ---------------- ----------- ---------------- ----------- ---------------- ---------- ------ -------------------------------------------------------------------------------- -------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------------------------------------------------------------- --------
41 KOALA KOALA KOALA 2009-10-22 23:39:53 0 N trunc(add_months(sysdate,2),'mm')-1/24 2 proc_auto_create_table; NLS_LANGUAGE='SIMPLIFIED CHINESE' NLS_TERRITORY='CHINA' NLS_CURRENCY='RMB' NLS_I 0102000200000000 0SQL>
Cause: Backtrace message as the stack is unwound by unhandled exceptions.
Action: Fix the problem causing the exception or write an exception handler for this condition. Or you may need to contact your application administrator or DBA.
奇怪,楼主看下alert log里面有没有其他有用的信息,如果可能把数据库重启下在执行看看..
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => 'proc_auto_create_table;'
,next_date => to_date('2009-10-22 16:10:00','yyyy-mm-dd hh24:mi:ss')
,interval => 'trunc(add_months(sysdate,2),''mm'')-1/24');
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END;
dbms_job.remove(JOBNO);再进行下面的操作试试
SQL> variable job1 number;
SQL> begin
2 dbms_job.submit(:job1,'proc_auto_create_table;',to_date('2009-10-22 16:10:00','yyyy-mm-dd hh24:mi:ss'),
3 'trunc(add_months(sysdate,2),''mm'')-1/24');
4 end;
5 /PL/SQL 过程被成功完成
job1
---------
41SQL>
SQL> begin
2 dbms_job.run(:job1);
3 end;
4 /