Oracle DB 12.1.0.2
AIX
Hello Team,
on my database, the timezone is -7. I would like to setup my scheduler jobs to Asia/Dubai GMT +4.
Can anyone pls help?
BEGIN
DBMS_SCHEDULER.CREATE_JOB
(
JOB_NAME => 'JOBBIGLBALANCE3',
JOB_TYPE => 'PLSQL_BLOCK',
JOB_ACTION => 'BEGIN DBMS_MVIEW.REFRESH(MV_BI_GL_BALANCES,method=>F,nested=>TRUE); END;',
NUMBER_OF_ARGUMENTS => 0,
START_DATE => SYSTIMESTAMP,
REPEAT_INTERVAL => 'FREQ=MINUTELY;INTERVAL=15',
ENABLED => TRUE,
AUTO_DROP => FALSE,
COMMENTS => 'JOB TO REFRESH'
);
END;
Thanks,
Roshan