Description:
The below steps describe who Apex used to call the Oracle JOB scheduler and Java users to create in oracle EBS with examples.
l Create the HTML link on apex
l Ajax(Application Process) used to call the DBMS_SCHEDULER then generate the job name
L 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 );
Summary:
This Post described the script Create Project party in oracle Apex used to call the Oracle JOB scheduler and Java in oracle EBS.
Queries?
Do drop a note by writing us at doyen.ebiz@gmail.comor use the comment section below to ask your questions.
