Unfortunately Microsoft’s Project Server 2010 doesn’t allow an administrator to set default settings for Notifications for all Users. They basically would have to go into their “Personal Settings > Settings for my Alerts and Reminders” themself and set the notification settings for Tasks, Status Reports, etc.
And as we all know: the User’s won’t do it.
So I had to figure out a way how I can “force” my Users to receive certain Notifications. After various Google Search Queries I had to realize, that there is no other way than digging into the database directly (although NOT SUPPORTED BY MICROSOFT!) and add the reminders for my Users manually (if this is not true, please let me know!!).
- Affected Database:
- ProjectServer_Published
- Required Tables:
- dbo.MSP_REMINDER_SUBSCRIPTION
- dbo.MSP_REMINDER_DEFINITION
- dbo.MSP_RESOURCES
Step 1
Connect to your Project Server Database using the SQL Server Management Studio
Step 2
Navigate into the “ProjectServer_Published” database and it’s table named “dbo.MSP_REMINDER_SUBSCRIPTION”
Step 3
Using an SQL-INSERT-Query, you need to add for each user a connection between the desired REMINDER_UID and it’s RESOURCE_UID to the previously mentioned table (step 2). Here’s an example Query:
INSERT INTO
[prj_ProjectServer_Published].[dbo].[MSP_REMINDER_SUBSCRIPTION]
([REMINDER_UID], [RES_UID], [RECIPIENT_TYPE], [FREQUENCY_PERIOD],[FREQUENCY_VALUE],[NEXT_RUN],[CREATED_REV_COUNTER],[MOD_REV_COUNTER])
VALUES
('A Reminder UID Number', 'A User UID Number', 1, 1, 1, '2011-12-08 00:00:00.000', 0, 0)
Hi Ofir,
First, the [RES_UID] you can find in the Resources Table: dbo.MSP_RESOURCES
Second question I cannot answer by heart. I think you should make a “SELECT Top 1000 rows” query on the dbo.MSP_REMINDER_DEFINITION table and then check for your actions, and add a Reminder Subscriptions with the according [REMINDER_UID] found in the definitions table.
Hope this helps. Unfortunately I do not have access to a MS Project Server anymore, why I can’t very above information 🙁
Best regards,
Oliver