Solved

Best solution for creating a regularly scheduled event.

Posted on 2006-06-09
4
254 Views
Last Modified: 2010-04-23
I am primarily an ASP.NET developer using VB.NET.  Occasionally I have the need to write an app that periodically (weekly) does some action (ie. send an email, create a report) based on data.  What are some methods to accomplish this task?

My current solution is to create an .aspx page that does the process and then schedule it via Windows scheduler and a .bat file.  This is prone to issues and I would prefer a more "solid" solution.

Thanks.

Jack.

0
Comment
Question by:JackWooten
4 Comments
 
LVL 44

Accepted Solution

by:
bruintje earned 500 total points
ID: 16871702
Hi JackWooten,
----------

best solution is something debateable

why not do it all in VB.NET without using ASP? and schedule that process on the windows scheduler?

you could also use is the SQL Server Agent which is almost always up :)
building a DTS script that is scheduled on the SQL Server and does the file send for you since its close to the data building the report is also very robust

----------
bruintje
share what you know, learn what you don't
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now