データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。

要約

When a mention is done, a notification is sent to the mentioned user. How to change the default interval to send this notification?

診断

There are multiple mail handles that might be sending the mention notification:

Jira Batch Notification enabled

Check at the Administration > System > select "Batching Email Notifications" under the "Mail" session if the batch notification is enabled.
The notifications are being controlled by the following Scheduler Jobs:

• At the Administration > System > select "Scheduler Details" under "System Support", search for the job com.atlassian.jira.plugins.inform.batching.cron.BatchNotificationJobSchedulerImpl;
• By default, this job runs every one minute.

• Run this DB update to change the interval of the job - in this case, changing to 2 minutes (120000 ms).

  update clusteredjob set interval_millis = 120000 
  where job_id = 'com.atlassian.jira.plugins.inform.batching.cron.BatchNotificationJobSchedulerImpl'

Jira Batch Notification disabled

When a new event occurs that triggers a notification, the Jira non-batched notifications go straight into the Mail Queue Service (no job involved).
You can change the interval following the instructions below, but they will affect all the notifications, not only the mentions:

• Mail Queue Services are scheduled to be running by default at once per minute. But sometimes due to user preference, it can be altered to different delays and this will take a direct effect on how long it will be delayed to reach the end-user.
• This can be verified by navigating to Administration > System > select "Services" under the "Advanced" session. The default value for the Mail Queue Service is Advanced > 0 * * * * ? which means every minute.

Using Service Management 

Service Management mail handler relies on the 2 following Jobs:

• sd.custom.notification.batch.send
  • When no customer notifications are triggered, this job does not run at all
  • When customer notifications are triggered, this job runs every 1 minute

• Run this DB update to change the interval of the job - in this case, changing to 2 minutes (120000 ms).

  update clusteredjob set interval_millis = 120000 
  where job_id = 'sd.custom.notification.batch.send'

• Mail Queue Service
  • Runs every 1 minute by default (can be configured, same as when Jira Batch Notification is disabled).