Sending mail in C#.net using Task shedular at specific time

sanjay ch

How I can send mails at specific time in C#.net windows applications using Task shedular.

The process in such a way that date and time will be in sql server database table , program code in windows application , in code the datetime obj is created

and set to match with table column value, if value match with current system time , task shedular should send automatically.. pls can any body help me..

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanjeeb Lenka13y ago
Hi sanjay,

Better you use Sql Job to do it........

http://databasebestpractices.com/sending-email-sql-server-agent-job-operators/
0
Jignesh Trivedi13y ago
hi,
if you can also use SQL job instead of any C# code...

Please refer
http://technet.microsoft.com/en-us/library/ms187910.aspx

hope this will help you.
0
Hardik Patel13y ago
hiii,

you can do this by Task Scheduler,

first create visual basic script file (.vbs) and paste in the project folder

refer attchment to create task to send mail automatically
code,

Call LogEntry()

Sub LogEntry()
On Error Resume Next
Dim objRequest
Dim URL
Set objRequest = CreateObject("Microsoft.XMLHTTP")
URL = "http://localhost/DailyReport/Default2.aspx" // your website path
objRequest.open "POST", URL , false
objRequest.Send
Set objRequest = Nothing
End Sub

one more thing : write send mail code in page load event..
it will send mail automatically without open any link.

0
Hardik Patel13y ago
it is only possible by webservice.
0