Monday, April 19, 2010

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

No comments:

Post a Comment