PL/SQL (MOSC)

MOSC Banner

Trouble with DBMS_SCHEDULER email notifications

edited Oct 7, 2019 5:04AM in PL/SQL (MOSC) 1 commentAnswered ✓

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center