Skip to main content

Email Notifications After Scheduling a Task

Ambreen Umair
  • Updated

Overview

A user schedules a mailing and then enables the scheduled task "Complete refresh of mailing stats" in order to have an automatic update of mailing stats and also sets it to run every X minutes.

The user may want to know why are emails being received every X minutes with subjects such as the following and whether this is a matter of concern or not.

(GREEN) xxxxxxxxxx Query INSERT INTO lyrClusterMutexLock (MutexName NodeID... finished (Total running time 33 seconds)
(GREEN) xxxxxxxxxx Query mssql_full_rep_sum_update finished (Total running time 114 seconds)
(YELLOW) xxxxxxxxxx Query INSERT INTO lyrClusterMutexLock (MutexName NodeID... has been running for 23 seconds
(YELLOW) xxxxxxxxxx Query mssql_full_rep_sum_update has been running for 23 seconds

The emails would include some content as follows:

Alert Description: Query: "INSERT INTO lyrClusterMutexLock (MutexName, NodeID..." has been running 
for 23 seconds Alert Recipients: XXXXXXXXXX Alert Start Time: Mon, 25 Jan 2021, 19:31:24 Alert 
Duration: 0 seconds Alert Transaction Log:
Thread: 'Complete refresh of mailing stats; record finish time in DB'
Full Query: INSERT INTO lyrClusterMutexLock (MutexName, NodeID, LockTime, ExpirationTime) VALUES 
('REPORT_SUMMARY_UPDATE', 2, '2021-01-26 03:31:00', CAST(GETUTCDATE() as smalldatetime) + 
0.041667 )
Alert Description: Query: "mssql_full_rep_sum_update" finished (Total running time: 114 seconds) Alert 
Recipients: xxxxxxxxxxx Alert Start Time: Mon, 25 Jan 2021, 19:31:24 Alert Duration: 91 seconds 
Alert Transaction Log:
Thread: 'Incremental update of mailing stats; record finish time in DB'
Full Query: mssql_full_rep_sum_update

Information

These emails are alerts for scheduled tasks that are mentioned in the "Thread:" tag in each email. In the examples above, it can be seen that the following scheduled tasks would have initiated them.

  • The scheduled task "Incremental update of mailing stats" is responsible for updating the mailings stats seen on the ListManager homepage dashboard and the "Mailings: Mailing Status: All Outgoing Mailings by Date".
  • The scheduled task "Complete refresh of mailing stats" is responsible for updating the mailing statistics automatically.

Likewise, the user can expect similar email notifications from scheduled tasks running in Lyris LM.

Change Task Scheduler Settings

The frequency of these alerts can be changed by editing the relevant scheduled task that is initiating them. Edit a scheduled task as follows:

  1. Navigate to "Utilities > Administration > Server > Server Settings > Scheduled Tasks"
  2. Find the desired task and click the "edit" link corresponding to it
    • It may be necessary to click "Show more" to see the desired task.
  3. Change the running interval. 
  4. Click "Save"

Note: The yellow alerts received indicate that it is taking a little longer than expected to run but should not be causing an issue. The green alerts are informational.

Related Articles

ListManager - Schedule a Mailing

Enabling the Mailing Stats Auto Refresh