将1个job定义在每周六执行,但是报ora-01846,
是因为定义job的时候,next_day参数日期是英文,
但是 select * from v$nls_parameters a where a.PARAMETER='NLS_DATE_LANGUAGE';
是SIMPLIFIED CHINESE,
修改参数alter session set nls_date_language='american';
然后重新执行Job
declare
jobnum number;
begin
dbms_job.submit(jobnum,
'REFRESH_DETAILADDRESS;',
sysdate,
'next_day(trunc(sysdate),''Saturday'')');
end;