Solved

Best solution for creating a regularly scheduled event.

Posted on 2006-06-09
4
258 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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 …
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…

717 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