Immediate alerts and email notification not getting send Moss 2007

Many time during the business hours we receive this type of issue. following steps may help to resolve this issue.

Scenario : Email accounts are setup , alerts was working earlier , suddenly users stop receiving alerts.


This could be caused by Timer service locked the content database and alerts are getting stuck in queue.

Use query to check by which server timer service is locked  (Off course if you have multiple server farm environment)

#1
use [Your Content database]
select * from timerlock (nolock)

You can also check what event cache table is holding currently

#2
SELECT * FROM eventcache WITH (nolock) WHERE EventData is not null

If you see large no of items in queue you may go ahead and restart the timer service on the server. (First query will give you server name)

Actual alerts sending can take 20 min of time and can be verified  running second query again . If everything goes well you should see no record pending in second query output.

Add Views to survey list

SharePoint handles Survey list little differently than the custom list or document library. So the new views cannot be crated on survey as on Custom list.

To achieve this follow these steps:

1. Get the GUID Url of the list on which you have created view.

   Easiest way to do so is 

Go to Site Action -> Site Settings 

Under Site Administration tab , Select Site library and lists

Select Customize “Your List name”

Notice in address bar you will get URL something like

http://WebapplicationName/sites/SitecollectionName/_layouts/SurvEdit.aspx?List={825760CD-090B-411F-805A-0C4796B50081}

a.       Yellow Highlighted part show GUID of your list

b.      Green Highlighted part shows type of list

2. Update URL

c.       Update “SurvEdit.aspx” with “ViewType.aspx”

d.      Remove  {} from GUID

e.      Url should look like

http://WebapplicationName/sites/SitecollectionName/_layouts/viewType.aspx?List=825760CD-090B-411F-805A-0C4796B50081

3. Past this new url in address bar , this will give view creation interface as we usually get for custom list or document library.