[JIRAALIGN-1996] Time Tracking Emails notifications not being sent

Issue Summary

The Backoffice service has a Task called ScheduledEmails which is responsible to InsertWeeklyScheduledEmails. In specific scenarios, the query execution times out.

Exception: System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out

Steps to Reproduce

Specific scenario - not able to replicate

Expected Results

The query runs with success.

Actual Results

The query execution times out.

Workaround

None available