AOP_SAMPLE24_PKG
Constants
Others
-- c_y
c_y constant varchar2(1) := 'Y'
Others
-- c_aop_version
c_aop_version constant varchar2(6) := '24.1'
SCHEDULE_AOP_API_PKG Procedure
BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'AOP_IR_JOB',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN
aop_sample_pkg.schedule_aop_api_pkg;
END;',
start_date => SYSDATE,
-- change to your requirement
--repeat_interval => 'FREQ=DAILY',
--end_date => sysdate+1,
enabled => TRUE,
auto_drop => TRUE,
comments => 'Creation of interactive report every day and email it out');
END;
Syntax
procedure schedule_aop_api_pkg