The batch file is meant to run a python script, and works fine when I run it from windows. When the job is run, it says succeeded, but nothing happens. Does anyone know how to get scheduler to run bat files, or to just directly run a python script?
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => '"SYSTEM"."TEST"',
job_type => 'EXECUTABLE',
job_action => 'C:\Users\awan\Desktop\test.bat',
number_of_arguments => 0,
start_date => NULL,
repeat_interval => NULL,
end_date => NULL,
job_class => '"SYS"."DBMS_JOB$"',
enabled => FALSE,
auto_drop => FALSE,
comments => '');
DBMS_SCHEDULER.SET_ATTRIBUTE(
name => '"SYSTEM"."TEST"',
attribute => 'store_output', value => TRUE);
DBMS_SCHEDULER.SET_ATTRIBUTE(
name => '"SYSTEM"."TEST"',
attribute => 'logging_level', value => DBMS_SCHEDULER.LOGGING_OFF);
DBMS_SCHEDULER.enable(
name => '"SYSTEM"."TEST"');
END;