Trouble with DBMS_SCHEDULER email notifications
I am working in Oracle 12c revision 2 with SQL Developer version 18.2.
I have a procedure made that executes multiple DBMS_SCHEDULER packages to execute a script to transfer a file and send me an email notification once it is done. Below are the DBMS_SCHEDULER packages that I am calling and the arguments that I am passing to them.
DBMS_SCHEDULER.CREATE_JOB
(job_name => job_name
,job_type => executable
,job_action => path/to/script/
,number_of_arguments => 1
,enabled => FALSE
,auto_drop => TRUE
);
DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE
(job_name => job_name
,argument_position => 1
,argument_value => name of file to be transferred