How to identify batched notifications information in the database
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Purpose
Find the information regarding batched notifications in the database
Solution
To verify if mail batching is enabled, run the following query:
SELECT * FROM feature WHERE feature_name = 'mail.batching.enabled';
If there are no result returned, mail batching is not enabled.
To find the scheduled job for mail batching, run the following query:
SELECT id, job_id, interval_millis, first_run, next_run FROM clusteredjob WHERE job_runner_key LIKE '%batch%';