Error Monitoring Notification system

Question

0.00/5 (No votes)

See more:

Hello Friends

I don't know in which section I should ask this question, at language part of SQL part. The problem is my system has a table in which my system logs success result as well false result. Now what I want when my system found 10 error result continuously in table, system should send a mail notification to me about this.

Thanks in advance

Posted 24-Feb-14 4:53am

darora85

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Accepted Answer · 2014-02-24T06:01:00

For something like this I would recommend writing either a Windows Service or a Windows Command Line utility. If you do a service, then use a timer to fire off however often you want to check the count. If you use a Utility, then you can schedule it using Windows Scheduler.

Personally I don't like using Sql to send emails, although it can. I like having that logic be outside in C# code which is why you should do a service or windows app.

Or, you could look at what process is writing records to that table and put the logic there.

Or, you could use a trigger and keep it all in sql and using the email feature of Sql but I would recommend against that.