In Practical scenario when we find SharePoint email alerts for lists not working then these steps can be executed as a part of the troubleshooting step:

1) Go to Central Admin ---->Operations----->outgoing email settings and verify that SMTP server is mentioned correctly 

2) Test the connectivity with the SMTP server.

     In order to do that follow these steps:

  •   Open  cmd
  •   telnet <SMTP server name> 25 ( We connect smtp server to the port 25)  
                 you should see a response  like this 220 <servername> Microsoft ESMTP MAIL Service, Version: 6.0.3790.3959 ready at date and time
                 Beware that different servers will come up with different settings but you will get something
                 If you dont get anything then there could be 2 possible reasons, either port 25 is blocked or 
                 the smtp server is not responding.
  •   For testing response from your server
                   For testing response say ehlo to it.
                        Type :
                                    ehlo <servername>
                                    250 <servername> Hello [IP Address]
  •   Now a test mail can be sent from that SharePoint server. 
                      Now we need to enter the From address of the mail.
                      Type :
                       mail from:
                       250 2.1.0….Sender OK
  •  It's time to enter the recepient email address.
    Type : rcpt to:
    250 2.1.5
  •  Now we are left with the data of the email. i.e. subject and body.
    Type : data
    354 Start mail input; end with <CRLF>.<CRLF>
  • Type:
    subject: this is a test mail
    This is test mail body
    I am testing SMTP server.
  • Hit Enter, then . and then Enter.
    250 2.6.0 <<servername>C8wSA00000006@<servername>> Queued mail for delivery
  • Type: quit
    221 2.0.0 <servername> Service closing transmission channe

3)  Check alerts are enabled for your web application
      verify if the windows timer service is running or not.

      Run this stsadm command to check that
      Stsadm.exe -o getproperty -url http://SharePoint-web-App-URL -pn alerts-enabled

     This should return <Property Exist="Yes" Value="yes" />

     If you don’t get this, Enable alerts by:
     stsadm.exe -o setproperty -pn alerts-enabled -pv "true" -url http://SharePoint-web-App-URL

      If its already enabled, try turn off and turn on it back.

4)  Check the Timer job and Properties

       Go to
       MOSS 2007:  Central Administration > Operations > Timer Job Definitions (under Global Configuration)
       In SharePoint 2010: Central Administration > Monitoring > Review Job Definitions 

       Check whether the "Immediate Alerts" job is enabled for your web application. check these properties:

 stsadm.exe -o getproperty -url "http://Your-SharePoint-web-App-URL" -pn job-immediate-alerts

       The expected output is:

       <Property Exist="Yes" Value="every 5 minutes between 0 and 59"/>.  

       If you don’t get this, run the following command to set its value.

       stsadm.exe -o setproperty -pn job-immediate-alerts -pv “every 5 minutes between 0 and 59" -url http://Your-SharePoint-web-App-URL

5)  Check whether the account is subscribed for alerts and it has a valid email account. This should be the first thing to check if the problem persists for some users not for      all.

6)  Then check if at all those users have at least read permission for the list. Because the first mail should go out for every user without security validation but the next ones       won't be delivered unless the user has at least read permission.

7)  If it is happening for one user, can also try to delete and re add the user in the site.

8)  Most importantly , you should try this one.

      Run this SQL query to the content db < Select * from Timerlock>

      This will give you the name of the server which is locking the content database and since when.
      In order to get rid of that lock 
      Go to that server which is locking the content db and then restart the windows timer service.
      within some time it should release the lock from content db, if not then at the most stop the timer job for some time
      Once the lock will be released then try to send some alerts
      You will surely get the email alert.
I found this is the most probable reason for alert not working most of the time. We should start troubleshooting with above steps before coming to this step for any alert email issue but from step 1 to step 7 are best for new environments or new servers.

If the issue is like this ,alert was working before and suddenly stopped working without any environmental change then above conditions in step 1-7 should be ideally fine.

Even after this if it is not working, then you can try these few more steps too

9)  Try re-registering the alert template:
stsadm -o updatealerttemplates -url http://Your-SharePoint-Web-App-URL -f  "c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\XML\alerttemplates.xml" -LCID 1033

10)  Try to clear the configuration cache

I believe these steps altogether would definitely help every one to resolve the alert issue exists in their environments.