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 ?