Before 6 months I was working on one web portal, there was requirement to auto send mail to trial register users and that site was hosted on shared server and we are using sql server 2005 express edition. So there was only one option to create a scheduler in asp.net application.
At first time I faced so much problems, at finally I did like this
Note: Here I have tested the concept with database.
Srep1: Create a “Global.asax”.
Step2: Create one Class i.e DoSomeWork and write the code for insert in database like this and create a table in database with field Id,msg, and sentDate to check this concept
/// Summary description for DoSomeWork
public class DoSomeWork
public void DoSomeWorkWithDB()
//code for storing in database
// You can also write code for sending mail to some one on some condition
using (SqlConnection con = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=Test;Integrated Security=True"))
using (SqlCommand cmd = new SqlCommand("Insert into tblMsg(msg) values(@msg)", con))
cmd.Parameters.AddWithValue("@msg", "This is the test message");
Step3: In “Application_Start “ method of Global.asax file, use the timer concept and assign the time interval to run that block of code like this.
<%@ Application Language="C#" %>
<%@ Import Namespace="System.Timers" %>
void Application_Start(object sender, EventArgs e)
// Code that runs on application startup
System.Timers.Timer myTimer = new System.Timers.Timer();
// Set the Interval to 10 seconds (10000 milliseconds).
myTimer.Interval = 10000;
myTimer.AutoReset = true;
myTimer.Elapsed += new ElapsedEventHandler(myTimer_Elapsed);
myTimer.Enabled = true;
public void myTimer_Elapsed(object source, System.Timers.ElapsedEventArgs e)
DoSomeWork obj1 = new DoSomeWork();
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)
Step3: Now run the asp.net application. It will insert data in database in every 10 second.
Note: You have some better idea to do this task then feel free to share with me. You are always welcome.
Great work man!
Thank you jai. I m glad to know that you liked it.
Wouldn’t this be quite waist-full running a timer all the time?
Yes. This one is not acceptable in big project.There generally we used to create window job scheduler.
I have written one approach for doing that task.
If you use this type of tech..it will not affect that server response..bcz its keep on running on every 10 seconds…..For better choice go for window scheduler..tech
Thank you for sending your suggestion. I agree with you.But if somebody is working for small client and client has not their own server then we cannot use window job scheduler.
In my sample, I m running the timer every 10 sec.we can also set the timer to run only one time in whole day by increasing time interval.
hi chandra i want one help from you currently i am working in one food corporation.see.i want to take automatic backup from all my shop i:e my company counter will you let m e know how to take automatic back up. my project based on asp.net2.0 version for database we are using sqlserver2005. if you solve this issue its a great pleasure for me.
i try but not successful. kindly reply me aur mail me
This is eassy task only. Please refer this URL. You get idea to solve this problem using different approach
Could you share some more information regarding your requirement, so that i can give you sample code in my free time.
Thanks for the auspicious writeup. It if truth be told used to be a enjoyment
account it. Look advanced to more delivered agreeable from you!
By the way, how could we keep up a correspondence?
whoah this blog is excellent i love reading your posts.
Keep up the good work! You already know, a lot of
persons are looking round for this information, you can aid them greatly.