数据库调度错误ORA-27465:无效值freq=weekly;?byday=sun;byhour = 22;bymin

Question

    begin
Dbms_Scheduler.Create_Job(
job_name => 'JOB_HK_SALES'
,job_type => 'PLSQL_BLOCK'
,job_action => 'BEGIN leadcapture.delete_old_records_SND(); END;'
,start_date => '30-SEP-2016 22:00:00'
,repeat_interval => 'freq=WEEKLY; byday=sun; byhour=22; byminute=0; bysecond=0;'
,enabled => TRUE
,Comments => 'Job to housekeep table records.');
end;
/     

运行上述程序后，我得到以下错误

ORA-27465: invalid value freq=weekly;?byday=sun; byhour=22; byminute=0; bysecond=0; for attribute REPEAT_INTERVAL
ORA-06512: at "SYS.DBMS_ISCHED", line 99
ORA-06512: at "SYS.DBMS_SCHEDULER", line 262
ORA-06512: at line 2

Answer 1

语句语法正确。在编译脚本之前，您可以简单地检查脚本中不需要的字符。使用如下命令:

grep -aq -e '[^[:print:]]' create_job.sql