How to execute Windows Service automatically when a row inserted in the SQL Server Table?

Question

0.00/5 (No votes)

See more:

Hello everybody,

I am a .NET S/W Engineer. I have a problem in Windows Service i.e My windows service has to execute automatically and send SMS as soon as a row inserted in the table. I have created, deployed and installed my windows service successfully. but when I inserted into the table from my other project, my windows service is not executing. please give sample code with explanation on the same.

Posted 3-May-12 3:13am

madhu555

Updated 3-May-12 23:08pm

v2

Add a Solution

Comments

Mantu Singh 3-May-12 9:35am

I hope windows services run automatically after deployment when system starts.........

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)

Sandeep Mewara · Answer 1 · 2012-05-03T04:27:00

If you want to send the email as soon as a rows is inserted then may be you should try to send email via SQL Server and not windows service.

Have a look here: SQL SERVER – 2008 – Configure Database Mail – Send Email From SQL Database[^]

If you want to send it via Windows service then, may be add a new table in your DB to track new records or a new column in the existing table(where row is being added) that will keep a track if email sent for it or not. Windows service will keep pinging your DB table at certain interval. For example, 5 min, then every 5 minutes it will check if any new record was added in last 5 min. If so, an email will be sent regarding the same.

Decide by yourself, what you need based on requirement.