the time zone of systimestamp is not match the user_scheduler_jobs
From: Joan Hsieh <joanhsieh08_at_gmail.com>
Date: Wed, 12 Dec 2018 09:55:31 -0500
Message-ID: <CAEhBma6Ztg7gq7T5F9ywXSxcLj46HGG5JRkOdEvnKuRarucOQQ_at_mail.gmail.com>
Hi Listers,
12-DEC-18 09.47.28.000075 AM -05:00 Thank you so much.
Date: Wed, 12 Dec 2018 09:55:31 -0500
Message-ID: <CAEhBma6Ztg7gq7T5F9ywXSxcLj46HGG5JRkOdEvnKuRarucOQQ_at_mail.gmail.com>
Hi Listers,
we have some dbms_scheduler_jobs failed due to the timestamp is not
correct. it throw out tons of errors of ORA-08186: invalid timestamp
specified .
The last_start_date from user_scheduler_jobs returns -4:00,
12-DEC-18 10.43.17.198623 AM -04:00
but the systimestamp from dual returns -5:00. what we should do to get it
sync.?
SQL> select systimestamp from dual;
SYSTIMESTAMP
12-DEC-18 09.47.28.000075 AM -05:00 Thank you so much.
Joan
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 12 2018 - 15:55:31 CET