SELECT * FROM USER_JOBS
ORA-01873: the leading precision of the interval is too small
ORA-01873: the leading precision of the interval is too small
SELECT * FROM DBA_SCHEDULER_JOBS
ORA-01882: timezone region not found
After a removal of the suspected job, and recreating it again the issue was fixed.
"suspected job" - there was a lock in database, and the job session was terminated with ALTER SYSTEM KILL SESSION command.
BEGIN
DBMS_JOB.remove(23);
commit;
END;
/
SELECT * FROM USER_JOBS
commit;
END;
/
SELECT * FROM USER_JOBS
Now is working!
No comments:
Post a Comment