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.
| Author |
Topic |
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
 Posted - 2010-05-19 : 15:24:07
|
| I am running some scheduled reports using the subscription manager. I have created an SSIS package that will setup some variables and create a directory for the output based on the date and then run all the jobs for the various reports to output to that directory. I have setup an email task at the end to notify some employees when it has completed. However, I notice that the tasks will show "green" and completed, even if there is an error in the report itself or if the report is still running, so is there a way to query the Report server to find out if the reports are really done? thanks. |
|
|
|
|
|
Querying when automated reports have finished