Monday, 24 December 2018

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 );

2 comments: