Daily Task Notification to Resource who is not on the associated p

L

ljsexton

We have a resource who suddenly started getting daily notifications around
1st of Jan for task changes on a project for which this resource has no task
assignments and the actual task referenced in the email does not exist on the
project. Have no idea what is triggering these messages. Every one is going
to same resource at same time everyday. Just after Mid-Night. **We have a
nightly backup of our mssql db starts everynight at mid-night. Not sure if
there is a connection but that is the only consistent info I can determine.
Any assistance with this issue would be greatly appreciated.
 
L

ljsexton

Additional Info: It appears that these notices started about the same time we
executed a SQL script from the MPA Ezine 12/19/05 issue that is to do MASS
removal of the Deleted Tasks from resources timesheets so they do not have to
do them one at a time. The task being referenced must be from the original
execution which deleted a total of 3333 records. However, do not understand
what is continuing to trigger this notice everyday after mid-night. the SQL
script only runs weekly and so far this task has not shown up in the list of
items to be removed upon next execution.
 
G

Gary L. Chefetz [MVP]

The timing is quite expected; midnight is the default for when the reminder
service runs. It's therefore not surprising. You have an orphaned assignment
record. Find it, delete it. The reminder will go away.
 
L

ljsexton

Can you provide direction on what table(s) to look in for this orphaned
record? Where can I find the DB schema for this application?
 
G

Gary L. Chefetz [MVP]

You can find the data dictionaries for Project and Project Server installed
in the help directory on your server. Look for prjdb.htm and svrdb.htm
 
Top