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.  

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_PID


----------- ------------------------------ ------------------------------

CPU_USED

---

ADDITIONAL_INFO

---

20-APR-09 01.35.55.931000 PM -04:00
JBECKSTROM
EXTPROC_TEST  

FAILED                              27370

20-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-l

Received on Mon Apr 20 2009 - 12:40:26 CDT