How to send message on particular time using trigger?

Question

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!

Sumit Jolly · Answer

I take step back with my option for SQL Server Trigger because you want to run job at particular time. 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

Harshal Thakre · Answer

I found the solution: In Global.asax: void Application_Start(object sender EventArgs e) { // Code that runs on application startup ThreadStart tsTask = new ThreadStart(TaskLoop); Thread MyTask = new Thread(tsTask); MyTask.Start(); } static void TaskLoop() { // In this example task will repeat in infinite loop // You can additional parameter if you want to have an option // to stop the task from some page while (true) { string date=System.DateTime.Now.ToShortTimeString(); // if(date) // Execute scheduled task if (date == 19:00) { ScheduledTask(); // Wait for certain time interval System.Threading.Thread.Sleep(TimeSpan.FromHours(23.59)); } } } static void ScheduledTask() { //Task code which is executed periodical } void Application_End(object sender EventArgs e) { // Code that runs on application shutdown } void Application_Error(object sender EventArgs e) { // Code that runs when an unhandled error occurs } void Session_Start(object sender EventArgs e) { // Code that runs when a new session is started } void Session_End(object sender EventArgs e) { // Code that runs when a session ends. // Note: The Session_End event is raised only when the sessionstate mode // is set to InProc in the Web.config file. If session mode is set to StateServer // or SQLServer the event is not raised. }

Sumit Jolly · Answer

couple of thoughts: - 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 Thakre · Answer

but problem is still Coming... it properly working on local server but after hosting(godaddy server) it's not working. i talked with service provider and done some changes according to them like recycle and so on. but nothing happened finaly i removed global.asax

Sumit Jolly · Answer

Thanks Harshal for accepting my solution! Looking forward for more interactions in future!

Sumit Jolly · Answer

I liked this idea of using Thread at Application Start() 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

Sumit Jolly · Answer

good question: I say you can read it's T&C before making final choice. As you said whether it's free or chargeable or available for life time.... If doesn't suit you look for similar alternatives... twitter @sumitjolly

Harshal Thakre · Answer

I want to know that this service free for life time at without cost or i have to pay after someday. and one thing also->this is secure or not

Harshal Thakre · Answer

I want to know that this service free for life time at without cost or i have to pay after someday. and one thing also->this is secure or not

Harshal Thakre · Answer

i am using godaddy databsae server so i cant use sqlserver agent or window scheduler because window schedular work on my local system but i am accessing data from Godaddy server. please tell me how to achive with trigger

Sumit Jolly · Answer

There are many ways to achieve this e.g. # 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