dbms_scheduler.create_job (
job_name => 'Pos_acct_prod_dtl_vu_mv',
job_type => 'PLSQL_BLOCK',
job_action => 'Begin DBMS_MVIEW.REFRESH(''schemaname.Pos_acct_prod_dtl_vu_mv'',atomic_refresh=>false); End;',
start_date => '14-feb-2022 09:00:00 AM',
repeat_interval => 'FREQ=DAILY;INTERVAL=30',
enabled => TRUE);
END;
/
every 30 min
begin
dbms_scheduler.create_job (
job_name => 'Pos_acct_prod_dtl_vu_mv',
job_type => 'PLSQL_BLOCK',
job_action => 'Begin DBMS_MVIEW.REFRESH(''schema_name.Pos_acct_prod_dtl_vu_mv'',atomic_refresh=>false); End;',
start_date => '14-feb-2022 09:07:00 AM',
repeat_interval => 'FREQ=MINUTELY;INTERVAL=30',
enabled => TRUE);
END;
/
-- daily 3AM job
begin
dbms_scheduler.create_job (
job_name => 'run_load_sales',
job_type => 'STORED_PROCEDURE',
job_action => 'system.load_sales',
start_date => '01-MAR-2010 03:00:00 AM',
repeat_interval => 'FREQ=DAILY',
enabled => TRUE);
END;
--- 9pm
Begin
DBMS_SCHEDULER.drop_job (job_name => 'SEND_PRICE_ALERT_9PM');
End;
/
BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'SEND_PRICE_ALERT_9PM',
job_type => 'PLSQL_BLOCK',
job_action => 'Begin automail_price_alert_pkg.JREP_SEND_PRICE_ALERT_9PM(''55'',trunc(sysdate));
automail_price_alert_pkg.JREP_SEND_PRICE_ALERT_ALL_UNITS_9PM(''55'',trunc(sysdate));
END;',
start_date => '15-JUL-2022 09:00:00 PM',
repeat_interval => 'FREQ=DAILY',
end_date => NULL,
enabled => TRUE,
comments => '');
END;
----------week---
BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'AUTO_POCOSTPIRCE_REP',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN SEND_PO_COSTPIRCE_CHANGE_EXCEL; end;',
start_date => SYSTIMESTAMP,
repeat_interval => 'FREQ=WEEKLY;byday=MON;BYHOUR=6;byminute=00;bysecond=0;',
enabled => TRUE);
END;
/
BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'auto_stktrf_req_daily_4pm_octdec22_1',
job_type => 'PLSQL_BLOCK',
job_action => 'begin
auto_stktrf_req_daily_4pm_octdec22;
end;',
start_date => '04-OCT-2022 04:00:00 PM',
repeat_interval => 'FREQ=DAILY',
end_date => '31-DEC-2022 06:00:00 PM',
enabled => TRUE,
comments => '');
END;
/
------ to change time only--
begin
dbms_scheduler.set_attribute (
name => 'AUTO_STKTRF_REQ_DAILY_JOB',
attribute => 'repeat_interval',
value => 'freq=daily; byhour=22');
end;
/
exec dbms_scheduler.enable('SEND_PRICE_ALERT_4PM');
