This should fire every day at nine and display items that are:
- Due in 14 days
- Due in 7 days
- Due in 3 days
- Due in 1 day
- Overdue (for every day overdue)
This should ping the individual assignee next to it. If a task is unassigned, ping the entire team. In an ideal world, all issues are assigned so people don't get spam pinged.
Also, for an issue, do not display more than just the name. Instead, hyperlink it to the actual issue view link within the UI so they can click it to get the full picture if they need to.