FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / ORA - Oracle Database Error Codes - Search via specific error codes. / ORA-10560 Through ORA-19999 / ora 12012 ORA-12012: error on auto execute of job 101 / Latest Posts

RE: ora 12012 ORA-12012: error on auto execute of job 101

Admin — Thu, 17 Jun 2010 14:10:13 GMT

I am receiving following error in my og. But job is not broken and there are no failure. Any idea how tio fix it.
ORA-12012: error on auto execute of job 14
ORA-12005: may not schedule automatic refresh for times in the past

dbms_refresh.refresh('"ECOM"."CUSTRUN"');

Broken = N
Faliure = 0
Interval = trunc(sysdate)+23/24
Last Date =06/11/2010 10:02:15 AM
Next Date =06/11/2010 04:01:17 PM
ORA-12012: error on auto execute of job 14
ORA-12005: may not schedule automatic refresh for times in the past

What= dbms_refresh.refresh('"ECOM"."CUSTRUN"');

Here is the fix:

Date should be fixed to be:

trunc(sysdate+1)+23/24

RE: ora 12012 ORA-12012: error on auto execute of job 101

Admin — Tue, 15 Jun 2010 11:11:05 GMT

Re: ORA-12012: error on auto execute of job

query dba_jobs and dba_jobs_running

RE: ora 12012 ORA-12012: error on auto execute of job 101

Admin — Tue, 15 Jun 2010 11:10:43 GMT

I am getting the error 12012 auto execute job error but i ca't seem to find this job. The error that come is

ORA-12012: error on auto execute of job 101

ORA-02236: invalid file name

But querying user_jobs does not show this job, strange...

RE: ora 12012 ORA-12012: error on auto execute of job 101

Admin — Tue, 15 Jun 2010 10:58:55 GMT

Use :

select dbr.sid, s.serial#, s.username, dbj.*
from dba_jobs_running dbr, dba_jobs dbj , v$session s
where dbj.job = 144338;

to see what is being executed via the job (dbj WHAT column) and correct the incorrect PL/SQL syntax.

I don't recommend but If you want to kill the job; first make the job broken :

begin
dbms_job.broken(144338,true);
end;

and then kill the session that's running this job :

alter system kill session 'SID,SERIAL' immediate;

change SID and SERIAL# according to the output of first query.

ora 12012 ORA-12012: error on auto execute of job 101

Admin — Tue, 15 Jun 2010 10:58:37 GMT

ORA-12012: error on auto execute of job 101

ORA-12005: may not schedule automatic refresh for times in the past

I see Errors in my alert log , and these errors are generated every 5 minutes. It seems to be that some PL/SQL Block under SYSTEM is throwing these errors.

here is the error message in alert log.
++++++++++++++++++++++++++++++++++
Fri Feb 27 10:04:17 2009
Errors in file /u10/app/ORACLE/admin/dss/bdump/dss_j000_12401.trc:
ORA-12012: error on auto execute of job 144338
ORA-06550: line ORA-06550: line 1, column 531:
PL/SQL: ORA-00917: missing comma
ORA-06550: line 1, column 439:
PL/SQL: SQL Statement ignored
, column :
Fri Feb 27 10:09:17 2009
Errors in file /u10/app/ORACLE/admin/dss/bdump/dss_j000_12515.trc:
ORA-12012: error on auto execute of job 144338
ORA-06550: line ORA-06550: line 1, column 531:
PL/SQL: ORA-00917: missing comma
ORA-06550: line 1, column 439:
PL/SQL: SQL Statement ignored
, column :
+++++++++++++++++++++++++++++++++++++

I looked up into one of those TRACE file that it refers in ALERT LOG
---------------------------------------------------------------------------------------------
/u10/app/ORACLE/admin/dss/bdump/dss_j000_12515.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u10/app/ORACLE/product/10.2.0.1
System name: SunOS
Node name: oscora02z
Release: 5.10
Version: Generic_127127-11
Machine: sun4u
Instance name: dss
Redo thread mounted by this instance: 1
Oracle process number: 20
Unix process pid: 12515, image: oracle@oscora02z (J000)

*** ACTION NAME:(JOB_SNAP_TEMP_USAGE) 2009-02-27 10:09:17.131
*** MODULE NAME:(DBMS_SCHEDULER) 2009-02-27 10:09:17.131
*** SERVICE NAME:(SYS$USERS) 2009-02-27 10:09:17.131
*** SESSION ID:(312.17680) 2009-02-27 10:09:17.131
*** 2009-02-27 10:09:17.131
ORA-12012: error on auto execute of job 144338
ORA-06550: line ORA-06550: line 1, column 531:
PL/SQL: ORA-00917: missing comma
ORA-06550: line 1, column 439:
----------------------------------------------------------------------------------------------

So my question is , why is this 'JOB_SNAP_TEMP_USAGE' runnign every 5 minutes. How do i disable it or what happens, if i delete this JOB ?