Apex used to call the Oracle JOB scheduler and Java

  • Create the html link on apex
  • Ajax(Application Process) used to call the DBMS_SCHEDULER then generate the job name
  • Ajax(Application Process) used to call the DBMS_SCHEDULER .CREATE_JOB then Execute the job name

Example : 
          select DBMS_SCHEDULER.GENERATE_JOB_NAME(‘hariharhomes’) into jobnames from              dual;

          dbms_scheduler.create_job( job_name=>jobnames, job_type=>’executable’,
          job_action=>’/u01/app/oracle/product/10.2.0/ias/Apache/Apache/images/mani.sh’,                                enabled=>TRUE );

  • December 24, 2018 | 20 views
  • Comments