10gR2 dbms_scheduler No process is on the other end of the pipe (winxp)

From: Ronald Rood <ronald.rood_at_gmail.com>
Date: 23 Sep 2005 07:22:35 -0700
Message-ID: <1127485355.204367.66110@g49g2000cwa.googlegroups.com>

Hi, a little problem - trying to - using dbms_scheduler on windows XP. Who has a clue apart from the lack of a decent operating system ? ;-) db version is 10.2.0.1

SQL> begin
  2 dbms_scheduler.create_job('t1',
  3 job_action=>'C:\WINDOWS\SYSTEM32\CMD.EXE',   4 number_of_arguments=>3,
  5 job_type=>'executable', enabled=>false);   6
  7 dbms_scheduler.set_job_argument_value('t1',1,'/q');   8 dbms_scheduler.set_job_argument_value('t1',2,'/c');   9
dbms_scheduler.set_job_argument_value('t1',3,'c:\local\ODWRK\scrippy.bat');  10 dbms_scheduler.enable('t1');
 11 end;
 12 /

PL/SQL procedure successfully completed.

SQL> set echo off

JOB_NAME
STATUS

---

---

ADDITIONAL_INFO

---

T1
FAILED JOB_NAME
STATUS

---

---

ADDITIONAL_INFO

---

T1
FAILED
ORA-27370: job slave failed to launch a job of type EXECUTABLE ORA-27300: OS system dependent operation:accessing execution agent failed with status: 233
ORA-27301: OS failure message: No process is on the other end of the pipe.
ORA-27302: failure occurred at: sjsec 9
ORA-27303: additional information: No process is on the other end of the pipe.

---

contents of scrippy.bat:
dir *.* >c:\local\ODWRK\z.lst

---

Am I missing something ? I see no reason why this should not work. Thanks for any insights,
Ronald. Received on Fri Sep 23 2005 - 09:22:35 CDT