Hi All
I have a problem with the alerts in sharepoint server 2007. i have tried the
following. when an alert is created, the first email is sent

1. restarted the timer service
2. stsadm -o execadmsvcjobs
3. stsadm.exe -o setproperty -pn job-immediate-alerts -pv "every 5 minutes
between 0 and 59" -url http://.....
4. stsadm.exe -o setproperty -url .... -pn alerts-enabled -pv true
5. Checked the logs but nothing seems wrong.


Also,

My MOSS 2007 implementation is a Single Server or Web Server for small server
farms (All services run on this server)

I run the ff sql commands and on the content database

1. "Select * from timerlock" result shows a different server which is not the
MOSS 2007 server (the test MOSS 2007 server which does not interact in anyway
with my production server)

2. "Select * from eventcache where EventData is not null" , it returns all
alerts in queue.


Will removing the lock make the thing work? if so how do i do it.
The problem started after we lost power in the datacenter and the server
shutdown.

thanks in advance for the help.