Summer time failling in database processes

  • 16 April 2024
  • 0 replies

Badge +1
  • Do Gooder (Customer)
  • 3 replies

Hi all,


After the weekend of 30th of March, we switched to summertime in France. After that, we have alerts coming from system-defined monitoring in App Monitoring about background jobs “stuck” (request for this alert is : SELECT COUNT(*) FROM batch_job_count WHERE action LIKE '%Transaction_SYS.%' AND next_date < (sysdate - 15/86400) AND enabled = 'TRUE' AND status != 'RUNNING').


After a check, it seems the times are not set the same way in “Database Processes” (guess : UTC) and Background jobs schedules (guess : UTC+1).


Do you experienced same issue ? Is there any fix about that or shall we modify the request to have a correct alert ?

0 replies

Be the first to reply!