|
|
Hello Erman,
i would like to know how to insert the GMT for my scheduler as shown below
BEGIN
DBMS_SCHEDULER.CREATE_JOB
( job_name => 'MVW_TEST_REFRESH',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN
dbms_mview.refresh('MVCB_SUB_AR_AP', 'C',atomic_refresh=> false);
END;',
start_date => trunc(sysdate)+7/24, <<<<<<<<<<<<<<<<<<<<<<<<<<<==================================== If the start time is 06:00 a.m GMT +4 Indian/Mauritius, how should I change it?
repeat_interval => 'FREQ=HOURLY; INTERVAL=4; , <<<<<<<<<<<<<<<<<<<<<<<<<<<====================================
enabled => FALSE,
comments => 'Job to refresh materialized view MVCB_SUB_AR_AP'
);
end;
/
Regards,
Roshan
|
Locked
