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
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 Browsing for activities using lists and calendars.
- 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.