After How Many Days Are The Reminder Emails Sent?

Overview

Reminder emails are sent some days after the initial invitation when the end customer does not answer the survey. The time until the reminder email is sent varies from customer to customer and may vary even among solutions. This article explains how to know this time.

Information

The time the system waits before sending a reminder email is stored in an internal configuration. If you would like to know it, please create a support ticket asking this question to the support team, and they will come back to you with the answer.

<supportagent>

The time before sending the reminder email is configured directly in the SQL Server job that performs this task. These are the steps to get this value:

1. Find out the customer environment.
2. Connect to the database server.
3. Expand the SQL Server Agent and then the Jobs nodes on the Object Explorer.
4. Double-click the job named _V2 Assignment daily schedule - [environment], where [environment] is the customer environment without the number (e.g., if the environment is NA3, consider [environment] as NA).
5. Go to the Steps page.
6. Locate the steps that have the customer name and InvitationReminder in the name. The name must not have the Disabled_ prefix. When you find one, double-click it. Check the code in the Command field. There are two types of codes:
   • Simple version: get the value of the @howManyDaysAgo variable. In the example below, reminder emails are sent after 2 days of the first invitation.
     

     declare @EndDate datetime,@howManyDaysAgo int 
     set @howManyDaysAgo=2
     SET @endDate = DATEADD(ms,-2, DATEADD(day, DATEDIFF(day,0,GETDATE()-@howManyDaysAgo)+1,0))
     select @enddate
     exec spu_[customer]_[solution]_InvitationReminder @EndDate,@howManyDaysAgo

   • Complex version: get the value of the @howManyDaysAgo variable outside the IF clause. In the example below, reminder emails are sent after 3 days of the first invitation.
     

     DECLARE @endDate DATETIME
     ,@howManyDaysAgo INT = 3
     ,@timediff INT = 10;
     
     SET @endDate = DATEADD(ms,- 3, DATEADD(day, DATEDIFF(day,0,DATEADD(hh,@timediff,GETDATE())- @howManyDaysAgo)+1,0));
     
     IF (DATEPART(HOUR, GETDATE()) = 15)
     BEGIN
     SET @howManyDaysAgo = 4;
     SET @endDate = DATEADD(ms,- 3, DATEADD(day, DATEDIFF(day,0,DATEADD(hh,@timediff,GETDATE())- @howManyDaysAgo)+1,0));
     END;
     
     EXEC dbo.spu_[customer]_[solution]_Invitation_Reminder @endDate,@howManyDaysAgo;

7. Since the reminder emails are configured at the solution (aka template) level, check if there are other steps in the same job for the same customer that refer to other solutions. If that is the case, get the configuration for that solution as indicated in step 6. Build a table like the one below with all the solutions that have reminder emails configured for that customer:

   Solution	Days Until Reminder Email Is Sent
   Solution 1	2 days
   Solution 2	3 days
   Solution 3	2 days

8. Send the table you built to the customer.

</supportagent>