Question

Summer time failling in database processes

  • 16 April 2024
  • 0 replies
  • 9 views

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!

Reply