Checking when a dialog activity was last processed

You can view a timestamp in the DMACTATTR table that indicates the last time the trigger for a specific dialog activity was processed. This timestamp applies only to daily check triggers that run once a day. For example, if you want to know the last time the Customer Celebrates Birthday trigger was processed for a specific dialog activity, you can run an SQL statement to check the timestamp.

About this task

For a list of daily check triggers, see Types of Dialog activity triggers and when they are processed. There is no specific approach for verifying that a dialog activity ran beyond viewing the element statistics in the activity builder. Dialog activities run when the customers perform the events that are associated with the activity. For example, placing an order.

Procedure

Get the name of the dialog activity that you want to check.
In Management Center, the name is specified in the Name box in the properties view for the dialog activity. To find the dialog activity, see Finding marketing activities.
Connect to the database on the server that contains the dialog activity that you want to check.
Run the following SQL statement:
```
SELECT * FROM DMACTATTR WHERE 
DMACTIVITY_ID = 0 OR 
DMACTIVITY_ID = (SELECT DMACTIVITY_ID 
FROM DMACTIVITY WHERE 
NAME = 'activity_name');
```
Where activity_name is the name of the dialog activity.
The SQL statement returns two rows:
- For the row in which the DMACTIVITY_ID is 0: The timestamp shows the last time that the SendMarketingTriggers scheduled job processed any daily check triggers.
- For the row in which the DMACTIVITY_ID corresponds to the name of the dialog activity you specified: The timestamp shows the last time that the SendMarketingTriggers scheduled job processed the trigger for this specific dialog activity.