Tuesday, 14 October 2014

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

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete