Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1084
  • Last Modified:

Event based Scheduling of the reports

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
KavyaVS
Asked:
KavyaVS
  • 2
2 Solutions
 
Megan BrooksSQL Server ConsultantCommented:
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
 
KavyaVSAuthor Commented:
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
 
Megan BrooksSQL Server ConsultantCommented:
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now