Schedule Reminders - Activity Date Time token missing from Insert Tokens dialog; Email Greeting token evaluates empty; Fatal DB error when repeat is triggered

Hit a few issues while testing the 'send_reminders' Scheduled Job.

1. Activity Date Time token WORKS when included in the message template for the an Activity based reminder (

{activity.activity_date_time}

) - but it's not present in the Insert Tokens dialog. This seems like a commonly used token for activity-based reminders and should be in the list.

2. I included

{contact.email_greeting}

token in my reminder message template, and it evaluated empty in the email output even thought it is populated for the recipient (who is the activity assignee). Strangely, I also tried

{contact.last_name}

- assuming that all contact tokens were broken. However that token did work.

3. When the 'is_repeat' properties are set and triggered, I get a fatal error in the Job Log results
"Finished execution of Send Scheduled Reminders with result: Failure, Error message: DB Error: unknown error"

To recreate:
1. Add a Scheduled Reminder for Activities of Type = Interview. When = 1 day before Activity Date Time. Repeat = every 4 hours until 2 days AFTER Activity Date Time. Recipient = Activity Assignees
2. Add an Interview activity assigned to a contact and set activity date time to 2 days ago.
3. Run send_reminder scheduled job (from /civicrm/admin/job - click More -> Execute for that job)
4. Check Job Log