Scheduler Error
435911Mar 3 2008 — edited Mar 3 2008Hi all,
I could really use some help with the following errors. I have spent time reviewing the posts here but have not been able to resolve the issues. Here is what I am getting.
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.
What I am trying to accomplish is this;
From within my PLSQL Web toolkit application I want to run a procedure that executes a job to stop and start isqlplus.
I create the following 2 jobs.
begin
DBMS_SCHEDULER.CREATE_JOB (
job_name =>'ISQLSTART',
job_type =>'executable',
job_action => 'C:\WINDOWS\SYSTEM32\CMS.EXE /c C:\ISQLSTART.BAT >null',
enabled =>true,auto_drop =>false
);
end;
/
begin
DBMS_SCHEDULER.CREATE_JOB (
job_name =>'ISQLSTOP',
job_type =>'executable',
job_action => 'C:\WINDOWS\SYSTEM32\CMS.EXE /c C:\ISQLSTOP.BAT >null',
enabled =>true,auto_drop =>false
);
end;
/
ISQLSTART.BAT is
e:\oracle\product\10.2.0\db\bin\isqlplusctl start
ISQLSTOP.BAT is
e:\oracle\product\10.2.0\db\bin\isqlplusctl stop
Both of these files run when executed from a command prompt.
Oracle version is 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
Any help would be greatly appreciated.
Thanks.
Tom