Send notifications ONLY for tasks that have changed
I'm using notifications to alert my team that they've been assigned a task. I have 400 tasks and a team of 30 people. Every time I publish, all 30 people get a notification about all of their assigned tasks, which is overwhelming them and now the notifications are useless. I'd prefer to have notifications sent only for tasks that have changed during the current session.
We have fixed this issue for Project Server by changing SQL stored procedure [draft].[MSP_Notification_GetUpdatedAssignments]