Solved

Event based Scheduling of the reports

Posted on 2010-11-16
3
1,059 Views
Last Modified: 2012-05-10
Can I schedule to run the SQL report, based on event. When the event happened the report
executes otherwise not. it continously checking for the event flag.
How to do this? Can we use the rs.exe command utility? How to usei t?

Is there any  ways to do the event based  scheduling of the reports?
Crystal reports have this option.But with SQL reports I didn't see anything. Please let me know in detail how to do this?

Thanks
0
Comment
Question by:KavyaVS
  • 2
3 Comments
 
LVL 14

Assisted Solution

by:Megan Brooks
Megan Brooks earned 500 total points
ID: 34147820
You can use the ReportingService.FireEvent("TimedSubscription", id) method to cause a subscribed report to execute. When I used this feature in the past, I created a subscription for the target report and set it to run once, at a date and time that was in the past. I then used a task in an SSIS package to execute the report (emailing it). FireEvent was called only when the data in the report changed.

You can find one example of how to do this here.
0
 

Author Comment

by:KavyaVS
ID: 34151922
Open Report Manager click on Site Settings then click on Site settings Security.

14.   Press Edit next to Generate events

15.   Then Click on System Administrator.

16.   Check the Generate events task.

I didn't find the Generate events link on Site settings Security. What to do?

Thanks

0
 
LVL 14

Accepted Solution

by:
Megan Brooks earned 500 total points
ID: 34152834
Yes, the user that calls FireEvent needs to have "Generate events" privilege. If I remember correctly, it was possible to assign this to a system role using Report Manager in SQL Server 2005. With SQL Server 2008 you will need to connect to the report server using SQL Server Management Studio, where you will find the system roles at the Security-->System Roles node.

You can either edit "System Administrator" and add the "Generate events" privilege to that or you can create a new system role with the additional privilege. You could call it "Event source" or whatever you would like. I think that would be a much better practice than extending System Administrator, because users that generate events probably don't as a rule need System Administrator privilege.
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

This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

895 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

14 Experts available now in Live!

Get 1:1 Help Now