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 );
  • October 14, 2014 | 23 views