We are using notification services in our newsletter engine.
System details are:
OS Windows 2003.
SQL server 2005.
Its sprodic, but we are getting issues in odd pattern
1: Service recovery, some times system has low memory or other resource crunch and
stops all such services. In recovery settings we have configured it to re-start the service after failure (in pic).
sometime It doesn't; we have to manually restart this service. recovery setting we have configured it to re-start itself on subsequent failures.In event viewer it records error only one time for the failure, idealy it should log for every attempt.
Does it mean it tries to restart itself only once after failure?
2: When NS mark a workitem as fail, means what is criteria?
The retry schedule in adf file we have settings like
Last time it marked each notification as failed(in 3 to 4 workitem batches, for every retry (i.e 3 times)) but in SMTP logs 90% of recipient recieved this mail three time where as log table of NS db tells notification are failed. help me out.
Duplicate emails are client reported issue now:(.
at least can you tell me what % notification should be delivered to mark workitem as sucess.
in event log it shows "mail sending failed" hardly for 100 recipent of last work item. does it mean 900 recipeint recieved mail on first go.is this 'mark fail' criteria configurable?? if yes where is this?
- 已編輯 Docait 2012年2月17日 上午 05:13 miss spelld
Have you applied the latest SP for SQL Server 2005? I would recommend to submit a feedback to the Microsoft Connect at this link. This connect site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft Connect.
Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
- 已標示為解答 Peja Tao 2012年2月24日 上午 01:51