alerts not working….again…..damn

7 10 2009

Out of the blue, sharepoint alerts stopped working.
The symptom was strange:
Subscriptions to alerts DID work but subsequent alerts did not.
I looked everywhere.
Finally I found something in the sql table called dbo.TimerLock. Timer lock by a front end server.
I rebooted the server and ran the following commands:
1.stsadm -o getproperty -pn search-alerts-enabled
2.stsadm -o getproperty -pn search-immediate-alerts
3.stsadm -o getproperty -pn search-daily-alerts
4.stsadm -o setproperty -pn search-alerts-enabled -pv “Yes”
5.stsadm -o setproperty -pn search-immediate-alerts -pv “Every 5 minutes between 0 and 59”
6.stsadm -o setproperty -pn search-daily-alerts -pv “Everyday between 00:00:00 and 05:00:00”




One response

8 02 2011

I was facing the same on the production server. Restart was ruled out by network admin so here are the steps that resolved my issue:
1. 2 Web Front End Servers: WFE1 (primary with Central admin) and WFE2 (secondary). Clustered database environment on SAN.
2. Select * from TimerLock – gives you one record and tells which server is actually responsible for relaying emails. In my case, it was WFE2.
3. WFE2 timer service wasn’t working fine, so I stopped the timer service on WFE2.
4. Timeout to release the lock is 20 minutes – i read it but i need to find out where exactly I can see this value Or is there a way to reset it.
5. After 20 minutes, TimerLock table record value was reset to WFE1 which eventually resolved my issues of not relaying emails.
By the way, above steps are required – I did execute those (except set statements).
Hope this may help somebody.

Leave a Reply

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

You are commenting using your 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

%d bloggers like this: