Answers.Body: <p>I had an issue with Scheduled Reminders on Events recently and so looked at this to understand it more, so sharing what I found.</p>
  <p>The cron job that fires off Reminders is called <strong>Send Scheduled Reminders</strong>.  My issue was it was set to run just daily and thus any intraday reminder would not be sent on time.</p>
  <p>Scheduled reminders are stored in the <strong>civicrm_action_schedule</strong> table.  You can see the ID of the Entity e.g. Event, Contact field etc in the entity_value column.  The 'mapping_id' column tells you what type of Entity it relates to. Mappings are stored in the <strong>civicrm_action_mapping</strong> table.  To complete the picture, the <strong>civicrm_action_log</strong> table shows you what actions have taken place and with whom.</p>
  <p>You can see this system in action most clearly for Events. Create a test Event and then set a reminder e.g. one day before the start of the event, go to your SQL tool of choice and look at the entry in the civicrm_action_schedule table.  You'll see the ID of the Event itself is shown in that entity_value column, along with the type of recipient (e.g. participant_role) in the recipent column. The rest of the columns are pretty much self explanatory and you'll see the mapping_id relates to the Event entity type if you look.</p>
  <p>If you manually create a Scheduled Reminder through Administer &gt; Communications &gt; Schedule Reminders for something more obscure e.g. an email going out to a Contact entity on the anniversay of some event marked by a custom field, you'll see the entity_id as the custom field id stored in the  <strong>civicrm_custom_field</strong> table.</p>
  <p>So, you do need to understand the underlying details of the Entity that the reminder is for, but at least you can see them there!</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2022-07-04T12:10:18.883Z
Answers.LastActivityDate: 2022-07-04T12:10:18.883Z
Answers.UserDisplayName: ChumKui
Answers.Body: <p>AFAIK Scheduled Reminders are not actually queued, they are selected when the Scheduled Reminders cron job runs. But if they are queued you should be able to see them in the <em>civicrm_queue_item</em> table.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-27T16:11:40.423Z
Answers.Text: is there a way to view which reminders will be selected with the next cron run?
Answers.UserDisplayName: Yossi
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-27T16:49:24.843Z
Answers.Text: No without checking the code and the database I would guess :-)
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-27T14:50:23.643Z
Answers.LastActivityDate: 2017-11-27T14:50:23.643Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>Is there a way to view Scheduled Reminders that are scheduled to go out the next time the job runs? </p>
  
Tags: <scheduled-reminders>
Title: How can I view queued Scheduled Reminders?
ThreadText: # How can I view queued Scheduled Reminders?
  
  (Asked by: username_0 on 2017-11-26)
  
  Is there a way to view Scheduled Reminders that are scheduled to go out the next time the job runs?
  
  **Tags:** scheduled-reminders
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2022-07-04. Score: 2
  
  I had an issue with Scheduled Reminders on Events recently and so looked at this to understand it more, so sharing what I found.
  
  The cron job that fires off Reminders is called **Send Scheduled Reminders**. My issue was it was set to run just daily and thus any intraday reminder would not be sent on time.
  
  Scheduled reminders are stored in the **civicrm\_action\_schedule** table. You can see the ID of the Entity e.g. Event, Contact field etc in the entity\_value column. The 'mapping\_id' column tells you what type of Entity it relates to. Mappings are stored in the **civicrm\_action\_mapping** table. To complete the picture, the **civicrm\_action\_log** table shows you what actions have taken place and with whom.
  
  You can see this system in action most clearly for Events. Create a test Event and then set a reminder e.g. one day before the start of the event, go to your SQL tool of choice and look at the entry in the civicrm\_action\_schedule table. You'll see the ID of the Event itself is shown in that entity\_value column, along with the type of recipient (e.g. participant\_role) in the recipent column. The rest of the columns are pretty much self explanatory and you'll see the mapping\_id relates to the Event entity type if you look.
  
  If you manually create a Scheduled Reminder through Administer > Communications > Schedule Reminders for something more obscure e.g. an email going out to a Contact entity on the anniversay of some event marked by a custom field, you'll see the entity\_id as the custom field id stored in the **civicrm\_custom\_field** table.
  
  So, you do need to understand the underlying details of the Entity that the reminder is for, but at least you can see them there!
  
  
  ---
  
  ### Answer by username_2 on 2017-11-27. Score: 2
  
  AFAIK Scheduled Reminders are not actually queued, they are selected when the Scheduled Reminders cron job runs. But if they are queued you should be able to see them in the *civicrm\_queue\_item* table.
  
  > **Comments:**
  > **username_0**: is there a way to view which reminders will be selected with the next cron run?  
  > **username_2**: No without checking the code and the database I would guess :-)  
  
  ---
  
  