今天在自己电脑的数据库里使用job没问题,但远程访问其他电脑的数据库,使用job却出现了问题,望各位高手指教。以下是我定义的job(pro为存储过程名)SQL> variable jobnum number;
SQL> begin
2 dbms_job.submit(:jobnum,'pro;',sysdate,'sysdate+8/24');
3 commit;
4 end;
5 /
SQL> begin
2 dbms_job.run(:jobnum);
3 end;
4 /
ORA-12011: execution of 1 jobs failed
ORA-06512: at "SYS.DBMS_IJOB", line 406
ORA-06512: at "SYS.DBMS_JOB", line 272
ORA-06512: at line 3
jobnum
---------
67
SQL> select job, failures, broken from user_jobs;
JOB FAILURES BROKEN
---------- ---------- ------
67 3 N
SQL> begin
2 dbms_job.submit(:jobnum,'pro;',sysdate,'sysdate+8/24');
3 commit;
4 end;
5 /
SQL> begin
2 dbms_job.run(:jobnum);
3 end;
4 /
ORA-12011: execution of 1 jobs failed
ORA-06512: at "SYS.DBMS_IJOB", line 406
ORA-06512: at "SYS.DBMS_JOB", line 272
ORA-06512: at line 3
jobnum
---------
67
SQL> select job, failures, broken from user_jobs;
JOB FAILURES BROKEN
---------- ---------- ------
67 3 N
还有show parameter job
看看
job_queue_processes 应该大于0alter system set job_queue_processes integer =10;
看看是valid还是invalid
-------
STATUS
-------
VALID