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