DBA and SysAdmin World

May 23, 2009

SharePoint 2003 "Alert Me" does not work

Filed under: Problem, System Administrator — Tags: , , — solihinho @ 11:02 PM
SharePoint 2003 Issue
Our user suddenly raised an issue that she never got an alert anymore from her department portal if any changes happened on the document list. We’ve checked the SMTP etc and looks like it was working fine. Honestly we as SharePoint Administrator did not know how the way this alert works. So the last way we coulddo was asking for help from Microsoft support Big Grin.

Things need to be checked
Microsoft support asked us to do several things for investigating this issue. From this we also knew how SharePoint’s alert actually works.

1. Check whether we can get the first notification mail from SharePoint when we subscription “Alert me”.

2. Check whether we will get a new record in content database.
    · Actually, once we done some modification in library or list, the system will insert 
      a new record in database for "Mail Alert".
    · We can run the following command to check whether this record has be inserted to DB :
        SELECT * FROM dbo.EventCache ORDER BY eventtime DESC

3. Then, SharePoint timer job service will read the data from DB and send mail out.
    · NOTE : The timer job service will run every 5 minutes by default.
    · We also can run the following command to check it.
        Stsadm –o getproperty –propertyname job-immediate-alerts

4. After that, the record will be deleted from content database.

Problem Solve
From that guidance, we just realized that our SharePoint Timer service was off. After turned it on, the alert back to normal. If the guidance doesn’t help on your problem. It should be another component that you need to check such as the SMTP server etc.


1 Comment »

  1. Estimados

    Tengo un problema parecido, pero el esta enviando las alertas tardiamente. como por ejemplo se pone una alerta en un document list para que alerte cada cambio pero se modifica un documento en 28-Oct y resibimos la alert el 9-Dic.

    He revisado en el SQL con la siguiente consulta:

    select * from dbo.EventLog ORDER BY eventtime DESC

    y en el LOG no regresa nada.


    Comment by Carlos Viales — December 12, 2009 @ 5:11 AM

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: