There is lots of blogs already about this, but I have a little different scenario.
First I have exported site using stsadm –o export and then imported it to the same server as subsite. The site contained a list called UserTasks it have a contentType that inherits from Tasks.
The issue is that user does not get email alerts when a task has been assigned to. The original site still can send email notifications.
Sharepoint have a 4 tables in database related to this:
ImmedSubscriptions (Stores the alerts for emails that are sent immediately when changes occur)
SchedSubscriptions (Stores daily or weekly scheduled alerts)
EventLog (This table contains events for which only non-immediate alerts exist)
EventCache (This table contains a list of site events for which users have requested alerts. WSS inserts events into this table as they occur)
Scenario how I have resolved this is following.
First thing I checked ImmedSubscriptions table and found that a record related to this list is not created by import procedure. Created this record manually by copying from original site and changed fields accordingly.
stsadm -o updatealerttemplates -url <SubsiteUrl> -f "c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\xml\alerttemplates.xml" -LCID 1062
stsadm -o setproperty -pn job-immediate-alerts -pv "every 1 minutes" -url <SubsiteUrl>
restarted “Windows SharePoint Services Timer” service
And it worked! :)
Thanks to:
Mel Lota’s weblog
Daniel Pavelescu's Blog
sharepointalert.info
No comments:
Post a Comment