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.