scheduler job in windows
From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Mon, 20 Apr 2009 13:40:26 -0400
Message-Id: <49EC7B49.3406.000B.0_at_gcrta.org>
I am trying to run a bat file from the scheduler.
LOG_DATE
OWNER
JOB_NAME
JOB_SUBNAME
ACTUAL_START_DATE
RUN_DURATION
ADDITIONAL_INFO
20-APR-09 01.35.55.931000 PM -04:00
JBECKSTROM
EXTPROC_TEST
20-APR-09 01.35.55.900000 PM -04:00
+000 00:00:00
ORA-27370: job slave failed to launch a job of type EXECUTABLE ORA-27300: OS system dependent operation:accessing execution agent failed with s tatus: 2
Date: Mon, 20 Apr 2009 13:40:26 -0400
Message-Id: <49EC7B49.3406.000B.0_at_gcrta.org>
I am trying to run a bat file from the scheduler.
I am running:
BEGIN DBMS_SCHEDULER.CREATE_JOB
(job_name=>'extproc_test',
job_type=>'EXECUTABLE',
job_action=>'f:\temp\extproc_test.bat',
enabled=>true,
auto_drop=>true);
END ;
/
I get the below error. The "bat" does exist in the indicated directory.
LOG_ID
LOG_DATE
OWNER
JOB_NAME
JOB_SUBNAME
STATUS ERROR#REQ_START_DATE
------------------------------ ----------
ACTUAL_START_DATE
RUN_DURATION
INSTANCE_ID SESSION_ID SLAVE_PIDCPU_USED
----------- ------------------------------ ------------------------------
ADDITIONAL_INFO
20-APR-09 01.35.55.931000 PM -04:00
JBECKSTROM
EXTPROC_TEST
FAILED 2737020-APR-09 01.35.55.900000 PM US/EASTERN
20-APR-09 01.35.55.900000 PM -04:00
+000 00:00:00
1 56,13 4972+000 00:00:00.00
ORA-27370: job slave failed to launch a job of type EXECUTABLE ORA-27300: OS system dependent operation:accessing execution agent failed with s tatus: 2
ORA-27301: OS failure message: The system cannot find the file specified. ORA-27302: failure occurred at: sjsec 6a ORA-27303: additional information: The system cannot find the file specified.
SQL>
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 20 2009 - 12:40:26 CDT