Skip to main content
Question

Summer time failling in database processes


Forum|alt.badge.img+4
  • Sidekick (Customer)
  • 12 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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings