3 messages in com.mysql.lists.eventum-usersRe: question on reminder conditions| From | Sent On | Attachments |
|---|---|---|
| Guyot, Joseph T. | 12 Jul 2005 09:14 | |
| Guyot, Joseph T. | 12 Jul 2005 10:07 | |
| Bryan Alsdorf | 25 Jul 2005 23:01 |
| Subject: | Re: question on reminder conditions![]() |
|---|---|
| From: | Bryan Alsdorf (bry...@mysql.com) |
| Date: | 07/25/2005 11:01:39 PM |
| List: | com.mysql.lists.eventum-users |
Hi,
I will try to answer your questions.
Guyot, Joseph T. wrote:
greetings!
i wrote to you all a few weeks ago in regards to migrating eventum from a development environment to a production environment. all went well and as the user base grows, we get nothing but compliments on the system. thanks for the system and your previous guidance.
now we are trying to understand the sequence of events for the reminder system. i have some additional follow-up questions based on the scenario above:
what happens after 24 hours if the assignee does not make any changes to the issue? does the reminder fire again with the next cron job for the reminder script?
If no one updates the issue, the same reminder will not trigger again. Whenever a reminder runs, it creates an entry in a table. Next time the cron runs, it will check the table and see if an entry for the reminder/issue exists.
when you say, "...Eventum clears out the the reminder flag for that particular issue.", does that mean when the assignee performs some action on the issue, the reminder flag clears and no further reminders of that sort will be sent again for that issue? which table and field contains the reminder flag?
If any user updates the issue, or performs certain other actions, the reminder flag will be cleared. This means that the same reminder WILL trigger again for the issue (if the conditions match).
The eventum_reminder_triggered_action table holds this flag.
in the same scenario above, when is the first reminder sent? is it with the first cron job after submitting the issue with the reminder or after 24 hours?
The first reminder will be sent when the first cron job runs AND an issue matches the conditions you set for it. There are no hard coded reminders in Eventum, so it is totally up to you to decide.
i reviewed another post in this discussion group that described how to troubleshoot reminders and i have entered a valid email address in the general admin setting "Email Reminder System Status Information". we then setup an issue that would use the reminder system. however, i have yet to receive a troubleshooting email.
You will only get the troubleshooting email when an issue actually matches a reminder.
in our scenario, a reminder was sent when the next reminder cron job fired. we left the issue alone for the duration of the reminder condition, which was set to greater than one hour. we never received another reminder.
As previously stated, the same reminder will not trigger for the same issue unless the issue is updated.
on the other hand, notification emails are sent as expected. any thoughts on why the reminder troubleshooting email is not firing off? have we forgotten a setup procedure?
I hope I have understood your questions correctly, and have made things a little clearer.
Regards, /bryan




