Database Software

Hi all,

i am new with DBMS_SCHEDULER and my need is to create a job, without program and schedule, that i can call in an Apex app.
This job run a window *.bat* file via cmd.exe
I test the .bat with doubleclick and it work.
I test window run with the string

c:\windows\system32\cmd.exe/c C:/mycompletepath/myfilename.bat > nul

and it work.

I execute the following

execute DBMS_SCHEDULER.create_job (
			job_name=>'EIM_JOB',
			job_type=>'EXECUTABLE',
			job_action=>'c:\windows\system32\cmd.exe',
			number_of_arguments=>1,
			auto_drop=>FALSE,
			enabled=>FALSE,
			comments=>'Job Lancio EIM'
		);

and the job is created.

I execute this

execute DBMS_SCHEDULER.set_job_argument_value('EIM_JOB',1,' /c C:/mycompletepath/myfilename.bat > nul');
execute DBMS_SCHEDULER.enable('EIM_JOB');
execute DBMS_SCHEDULER.PURGE_LOG(job_name=>'EIM_JOB');
execute DBMS_SCHEDULER.run_job('EIM_JOB');

but the error ORA-27369: job of type EXECUTABLE failed with exit code: No such file or directory is raised

The argument is uge and reading about it here https://forums.oracle.com/forums/thread.jspa?threadID=701740 here https://forums.oracle.com/forums/thread.jspa?threadID=555102 and here http://www.oracle-base.com/articles/11g/SchedulerEnhancements11gR1.php_ i suppose that my problem is quite about credentials but i need some help or tips to clearly identify, verify and solve the problem.

Any kind of help will be appreciated.
Thanks

Alex