Introduction :
This describes how to use the DBMS_SCHEDULER package to work with Scheduler objects. You can accomplish the same tasks using Oracle apex
Steps to follow :
- 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 :
Step 1 : Generating the job name in run time process.
select DBMS_SCHEDULER.GENERATE_JOB_NAME(‘hariharhomes’) into jobnames from dual;
Step 2 : Calling the DBMS_SCHEDULER package with required parameters as given below.
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 );
Conclusion :
By executing the procedure, Job will be placed in the back end.
Recommended Posts
