Return
-
Title
Can SQL Navigator adjust the time for Job Scheduler if database is in another timezone? -
Description
When using Job Scheduler to run some scripts, if the database is in a different country / timezone, the start time set in SQL Navigator is not the time the job runs on the database. It starts at the time registered on the database server, not the client machine.
-
Cause
The oracle job scheduler is called, so when the task runs on the server side, the start time in the console may need to be adjusted to compensate. -
Resolution
WORKAROUND:
Adjust the start time of the job to compensate for time difference on database server
STATUS:
Enhancement request SQLNAV-2120 has been submitted to Development for consideration in a future release of SQL Navigator for Oracle. -
Defect ID
SQLNAV-2120