Solved

Scheduled reports -  sending via .Net 4.5, sql or Windows scheduled task?

Posted on 2014-03-21
3
248 Views
Last Modified: 2014-03-27
My Web app has the ability to generate reports

Now I want to schedule some reports,  I. E send at a certain time (configured by user)  every day

The usual way I know of is to write a console app and run it as a scheduled task

However I was doing that 10 years ago
Is there anything in. Net 4.5 or. Sql server that can automatically hit a Web service to generate the reports?
0
Comment
Question by:websss
[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
  • 2
3 Comments
 
LVL 13

Expert Comment

by:devlab2012
ID: 39946984
There is in-built functionality in reporting services. You can use report subscriptions. Here is a link for details:

http://technet.microsoft.com/en-us/library/cc872783.aspx
0
 

Author Comment

by:websss
ID: 39949635
Thanks
but i'm using telerik reporting which has .net code that is needed to run in order to send the reports
0
 
LVL 13

Accepted Solution

by:
devlab2012 earned 500 total points
ID: 39950984
Instead of creating a console application, you can achieve the same thing by creating a simple web page and a small vbs file. Here are step by step instructions:

1. Create a normal web page that will generate and send the reports. Write all the code in Page_Load as this page will not be used by a user, instead it will be called through code.

2. Create a vbs file to call this page. Use the complete url of the page in the vbs file.

3. Run the vbs file at a scheduled time using Windows Task Scheduler.

Here is a complete tutorial of creating vbs files to run a web page:

http://www.orcsweb.com/blog/using-task-scheduler-and-a-vbs-file-to-request-a-web-page-on-a-scheduled-basis/
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

740 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