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 |
|
Randomluck
Starting Member
4 Posts |
 Posted - 2011-02-17 : 18:39:06
|
| When a report subscription is running, how can we tell the report is running?Thank you |
|
|
Randomluck
Starting Member
4 Posts |
Posted - 2011-03-15 : 12:52:47
|
| Still no answer. I'm beginning to think this isn't possible. |
 |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-03-15 : 15:57:16
|
| Do you mean the report is "hung up" and still running the query or do you want to know if a subscription is still being generated and sent to the people who signed up for it?Hey, it compiles. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-03-16 : 09:18:52
|
| With ajthepoolman, the pool is always clean and sparkling!I liked working with SSRS. My old job used it and I really liked it compared to Crystal Reports.Hey, it compiles. |
|
|
|
Randomluck
Starting Member
4 Posts |
Posted - 2011-03-18 : 18:26:54
|
quote:
Originally posted by ajthepoolman
Do you mean the report is "hung up" and still running the query or do you want to know if a subscription is still being generated and sent to the people who signed up for it?Hey, it compiles.
Exactly, in the first scenario above. The Report job kicks off, but it never seems to return a data set. Even if the Report Server is rebooted so it is 'fresh'. Normally SSRS only generates run stats after the job is completed. Question is, how can we tell if a Report is still generating or it 'froze up'?Thanks. |
|
|
|
|
|
|
How to tell if a Report subscription is running