Click here to Skip to main content
15,888,401 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi guyz
i want to execute particular block of code at scheduled time in asp.net.

e.g on my website every morning at 8AM ,my database backup code must be executed.

i know how to backup db. but how the backup function will be invoked at scheduled time.


thnax in advance ;)
Posted

1 solution

You can use the SQL job to schedule the daily back up activity. ASP.NET is not needed for this purpose. You may find these links helpful :
1. http://support.microsoft.com/kb/930615[^]
2. http://cherupally.blogspot.com/2009/04/schedule-daily-backup-for-sql-server_27.html[^]
3. http://chkiran.wordpress.com/2008/06/04/schedule-daily-sql-server-2005-datbase-backup-using-sql-agent/[^]
4. http://www.brianmadden.com/blogs/guestbloggers/archive/2007/05/07/how-to-automate-the-backup-of-a-sql-server-2005-express-data-store.aspx[^]

If you want to schedule any other activity other than SQL Backup then I suggest you can have a look at Quartz.Net framework. This is an excellent framework which makes the Scheduling tasks easier.

Hope this helps.
All the best.
 
Share this answer
 
Comments
abhijeetgupta1988 8-Oct-11 6:19am    
hey i was not aware of quartz.net.

thnks for that.
i would love to explore it :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900