【 使用环境 】测试环境
【 OB or 其他组件 】
【 使用版本 】v4.2.1
【问题描述】使用 DBMS_SCHEDULER.CREATE_JOB 创建job任务，创建失败，报错如下：ErrorCode = 20000, SQLState = HY000, Details = ORA-20000: interval expression not valid: FREQ=DAILY;BYHOUR=4 at package body oceanbase.DBMS_SCHEDULER.CALC_DELAY_TS , line : 56, col : 1 at package body oceanbase.DBMS_SCHEDULER.CREATE_JOB , line : 85, col : 0 at anonymous block , line : 2, col : 0
【复现路径】
BEGIN
DBMS_SCHEDULER.CREATE_JOB(
job_name => 'name',
job_type => 'STORED_PROCEDURE',
job_action => 'procedure;',
start_date => sysdate,
repeat_interval => 'FREQ=DAILY;BYHOUR=4',
comments => '日常搜集'
);
COMMIT;
END/