10gR2 dbms_scheduler No process is on the other end of the pipe (winxp)
in [Oracle]
|
From: Ronald Rood on 23 Sep 2005 10:22 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.
From: sybrandb@yahoo.com on 23 Sep 2005 10:48 You are running the Windows Scheduler Service ? -- Sybrand Bakker Senior Oracle DBA
From: Ronald Rood on 23 Sep 2005 10:54 Hoi Sybrand, do you mean the OracleJobScheduler${ORACLE_SID} ? In that case yes, it's running, atleast, the services panel shows 'running'. thanks, Ronald.
From: Ronald Rood on 25 Sep 2005 15:38 On Fri, 23 Sep 2005 16:22:35 +0200, Ronald Rood wrote (in article <1127485355.204367.66110(a)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 / I just tested this - with slight modifications - on 10.1.0.3 on macosx and it works as expected. Is anybody using - or trying to use - dbms_scheduler on windows ? It should be platform independent so even on windows it should run .... With kind regards / met vriendelijke groeten, Ronald http://ciber.nl http://homepage.mac.com/ik_zelf/oracle
|
Pages: 1 Prev: ora: 1033 : Oracle intialization or shutdown in progress Next: default port for EM |