ENVIROMENT
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
Window 7 64 Ultimate
when I learned the DBMS_SCHEDULER package about external program ,
I find that argument search in c:\windows\syswow64, but created file in c:\windows\system32
if absolute directory path is not specified.
it is weird based on my poor little programming knowledge warning me that script full-path should
be the path in which files are created.
the code as following:
=================================================================
begin
sys.dbms_scheduler.create_job(job_name => 'SCOTT.PYTHON',
job_type => 'EXECUTABLE',
job_action => 'python.exe',
number_of_arguments => 1,
start_date => to_date(null),
repeat_interval => '',
end_date => to_date(null),
job_class => 'DEFAULT_JOB_CLASS',
enabled => false,
auto_drop => false,
comments => '');
sys.dbms_scheduler.set_job_argument_value(job_name => 'SCOTT.PYTHON',
argument_position => 1,
/*
this is the argument */
argument_value => 'helloworld.py');
end;
/