Eamil alert to senior management when their staff have overdue ta

[FOON]

Hi,
I have a question for MS project 2003 web access and project
professional

Eamil alert to senior management when their staff have overdue task

for example, I am a executive and 1 managers report to me. There
are 5 members of staff report to the manager. I want to get email
alert to me when any tasks assigned to those 5 members and the manger
are overdue. I tried to set up the resource break down structure and
using web access to config "Alert me about my resource on task and
status reports" but still did work.
It's note that I am not a project manager nor team member of the
project.

I search many reference books and internet resoure but no any better
solution

Any one can give me a halping hand to solve my problems?


Thak you very much

 

[Ed Morrison]

First, you should try and get the email alerts to work properly. Are other
emails alerts going out? It sends the email to the team member's direct
manager only.

If the built in feature does not meet your needs, you can either create a
SQL procedure that is started by a SQL Server Agent Job or an app started by
the Windows Scheduler.

Which ever option you choose, you must check the msp_web_assignments table
to determine which assignments are overdue (assn_start_date> today and
assn_rem_work>0). Then determine who should receive the email, either by
checking the RBS or some other method that you determine. Finally, send the
email by SQL Mail or another mailing method.

Hope this helps.