Re: Oracle job is not running

Posted by ErmanArslansOracleBlog on Sep 24, 2017; 3:28pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Oracle-job-is-not-running-tp3400p3577.html

connect to the database.
use "select sysdate from dual" and "SELECT SYSTIMESTAMP FROM DUAL;" to check the date of the database (default date), then set your job time accordingly.
You can also use the following to check:

select systimestamp,current_timestamp from dual;

SYSTIMESTAMP -> current timestamp on database serve
current_timestamp ->timestamp on client machine