I have db example:
Emp_Name Salary Date
------------- -------- -----------
Raj 2000 1-05-2014
Pavan 3000 1-07-2014
kumar 1000 1-07-2014
---------------------------------------------------
suppose today date- 1-072014
i want to send Email to my admin [email protected] at 7pm daily automatically of today transaction like...
Emp_Name Salary Date
------------- -------- -----------
Pavan 3000 1-07-2014
kumar 1000 1-07-2014
---------------------------------------------------
Total- 4000
-------------------------------------------------
Please give me some suggestion or code for trigger in ms sql server that i am able to send Emaill automatically 7 pm Daily.
Please help me!

Guest UserPosted Jul 12, 2014, 10:38 PM
I suggest you to explore https://www.setcronjob.com/ in such case.
So, you can schedule your .Net code to run @7pm which will send Email
Let me know if this is useful!
twitter @sumitjolly
Guest UserPosted Jul 26, 2014, 10:35 AM
- any error generated in logs at godaddy?
- did you put loggers in application_start etc event to see what's happening there?
- did you check with godaddy, if you can debug from your visual studio or there you can install visual studio express and debug it?
twitter @sumitjolly
Harshal ThakrePosted Jul 26, 2014, 7:50 AM
Guest UserPosted Jul 23, 2014, 2:22 PM
Guest UserPosted Jul 23, 2014, 9:49 AM
The other way to achieve this on similar lines is
# create a html page
# put SetTimeOut() function in JS and check for time say "19:00" to call .Net code
# and use AJAX to call .Net email sending code
The disadvantage of this html page approach is you need to have this file open at browser always.
I vote for your approach.
twitter @sumitjolly
Harshal ThakrePosted Jul 23, 2014, 9:17 AM
In Global.asax:
Guest UserPosted Jul 22, 2014, 8:06 AM
If doesn't suit you look for similar alternatives...
twitter @sumitjolly
Harshal ThakrePosted Jul 22, 2014, 6:33 AM
Harshal ThakrePosted Jul 22, 2014, 6:33 AM
Harshal ThakrePosted Jul 10, 2014, 6:10 AM
Guest UserPosted Jul 9, 2014, 9:18 AM
# Use SQLServer Agent and schedule job which runs at 7pm daily and send email
# Use Windows Scheduler and write C# code to send email
# In SQLServer you can write trigger at any DML operation and send email
twitter @sumitjolly