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

Question

0.00/5 (No votes)

See more:

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

Posted 28-Nov-12 4:09am

Sathish.K4

Add a Solution

Comments

[no name] 28-Nov-12 10:50am

Have you already created a procedure to send the email? You can create a schdeuled job after you have your email procedure set up, the job will just be you scheduled email procedure with your inputs for the email to send.

Sathish.K4 4-Dec-12 5:31am

Thanks Mathlab,
Now i learned SQL - Jobs will help me in this.. i'm slowly learning and Practicing(Bec i'm new to SQL) . Thanks for your suggestion :)

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)

jovenbarola · Accepted Answer · 2012-12-03T17:43:00

Solution 1

Hi,

Yes, SQL also have some features that can send message via mail
here is my suggested link for you to check out: http://www.sqlteam.com/article/sending-smtp-mail-using-a-stored-procedure[^]
(by the way i do not own this article, just i dont want to re-write the thing that is there)

I hope this helps,

Regards,
Joven

Posted 3-Dec-12 17:43pm

jovenbarola

Comments

Sathish.K4 4-Dec-12 5:34am

Hey Joven ,

Really thanks for your link .. Started learning from you people suggestions .. will come and ask , if i have any clarification :)