Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Reporting Service, Report Agent Service conflict

Author  Topic 

Tim Tisseret
Starting Member

2 Posts

Posted - 2009-09-03 : 12:02:56
I am using SQL Reporting Services timed subscriptions to create monthly reports. I turn on SQL Report Agent service, wait 15 minutes, and my monthly reports are done. It's not efficient but is my only alternative (SRS C# programmatic push output model doesn't work).

The problem with this is I need Report Agent to run routine DB backups.

Any ideas how I can programmatically run Report Agent and do backups,
or keep the Report Agent on and the 15 minute SQL RS Subscriptions off?
   

- Advertisement -