declare
l_job number := null;
begin
sys.dbms_job.submit(job => l_job,
what => 'begin PROC_BEGIN_BACKUP; end;',
next_date => sysdate + 1,
interval => '(trunc(SYSDATE))+1 +(22/ 24)');
commit;
end;
ORA-23319: parameter value "(trunc(SYSDATE))+1 +(22/ 24)" is not appropriate
ORA-06512: at "SYS.DBMS_JOB", line 57
ORA-06512: at "SYS.DBMS_JOB", line 129
ORA-06512: at line 4
SQL>
This work on 15 of my database except this one.
Any idea why?
Bookmarks