Hi
I have an oracle job created using dbms_scheduler.
After a few trials etc(trying different values for repeat_interval after giving minutely intervals etc, finally decided to create the job as follows:-
exec DBMS_SCHEDULER.drop_job(job_NAME => 'HOSTORDER',force => true);
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'HOSTORDER',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN hostorder_pkg.main; END;',
start_date => SYSTIMESTAMP,
repeat_interval => 'SYSTIMESTAMP + INTERVAL ''15'' MINUTE',
job_class => 'DEFAULT_JOB_CLASS',
auto_drop => FALSE,
end_date => NULL,
enabled => TRUE,
comments => 'Job to launch hostorder_pkg.main.');
END;
/
This job also creates a logfile so that I know the progress of the steps involved.
There is an intermittent problem observed(i.e sometimes this happens frequently and sometimes does not happen) that the job hangs on certain steps(on the hostorder_pkg) and doesnt pick up the next schedule.
So I always have to manually interfere and stop and restart the job.
When this is done, the job does not hang on the same step on next run , but some other times hangs, this is why I am saying its an intermittent issue.
Around the same time the "hang" happens, the alert log shows the following :-
Alert log
==========
Mon Jun 16 14:44:58 2014
Errors in file F:\APP\ORACLE\diag\rdbms\geooap\geooap\trace\geooap_j001_10740.trc:
ORA-12012: error on auto execute of job "GEOPROD"."HOST_JOB"
ORA-27369: job of type EXECUTABLE failed with exit code: Incorrect function.
Above trace file contents
=======================
Trace file F:\APP\ORACLE\diag\rdbms\geooap\geooap\trace\geooap_j001_10740.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU : 4 - type 8664, 4 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:3169M/8191M, Ph+PgF:7959M/20475M
VM name : VMWare Version (6)
Instance name: geooap
Redo thread mounted by this instance: 1
Oracle process number: 44
Windows thread id: 10740, image: ORACLE.EXE (J001)
*** 2014-06-16 14:44:58.801
*** SESSION ID:(6.19881) 2014-06-16 14:44:58.801
*** CLIENT ID:() 2014-06-16 14:44:58.801
*** SERVICE NAME:(SYS$USERS) 2014-06-16 14:44:58.801
*** MODULE NAME:(DBMS_SCHEDULER) 2014-06-16 14:44:58.801
*** ACTION NAME:(HOST_JOB) 2014-06-16 14:44:58.801
ORA-12012: error on auto execute of job "GEOPROD"."HOST_JOB"
ORA-27369: job of type EXECUTABLE failed with exit code: Incorrect function.
Please give me ideas on how to tackle this problem.
My database is Oracle 11.2.0.3.0 on 64 bit windows 2008