SQL Needs to Send a mail as per the date mentioned in Table

Sathish.K4 asked:

Hello All,

This is my 1st post in CODE PROJECT and new to C#.net(But i have Knowledge in C++ and VB).and started learning about c# and SQL server

I'm creating work allocation and TAT system, (we receive the Job tickets from customer each request has unique id,ticket tat end time )

i just created the windows form that import the excel from my pc and stores the data into SQL server(Table name:W_Allocation).this table have TAT start time,end time and Ticket status for each request.

What i'm expecting from you people is SQL needs to send a mail to me before 2 hour of TAT end time if the ticket status is pending

Someone said SQL Jobs can do this . But i have basic Knowledge in SQL and i dont know how to create SQL jobs programmatically from windows form.

Or is there any other way to do this, looking forward your responses,

Sincerely,
Sathish.K

Tags: C#, SQL Server

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

...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

Cancel

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.

Please note that all posts will be submitted under the http://www.codeproject.com/info/cpol10.aspx.