How to Test a Subscription

Hello,
I've currently got some email subscriptions setup to go out every 1 minute
(for testing purposes), but I'm not getting any emails and nowhere can I
find an error reported.
Is there a best practices for testing and troubleshooting subscriptions that
don't go out?
Any advice would be greatly appreciated!
Regards,
Benjamin PierceRegards,
I was able to figure out my problem -- it turns out that the ReportServer
Service was turned off (it's always the last place you look).
Just to share a little bit of knowledge with the RS users out there, here
are a few of the ways I personally troubleshoot subscriptions.
1) In the ReportServer database, execute the following query:
SELECT * FROM Event ORDER BY TimeEntered DESC
This will return the number of events in the queue. If items remain in this
queue for more than a minute or two, either the service is not on, something
is blocking in the database, or the service is hung.
2) Open SQL Enterprise Manager and check out the jobs. There should be a
job in your Enterprise Manager for each subscription. It might be useful to
look at the Event History, and check the error logs.
3) Of course, you'll also want to make sure you test the SMTP server that
you've got setup. A lot of the time the problem lies in the email setup
(possibly file sizes quotas, incorrectly configured email groups)...rather
than a Reporting Services thing.
Anyhow, I realize these tips are by no means advanced, but they've helped me
plenty of times and I hope they'll do the same for you.
Best Regards,
Benjamin Pierce
"Benjamin Pierce" <bpierce@.opentext.com> wrote in message
news:eonpvdcbEHA.796@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I've currently got some email subscriptions setup to go out every 1 minute
> (for testing purposes), but I'm not getting any emails and nowhere can I
> find an error reported.
> Is there a best practices for testing and troubleshooting subscriptions
that
> don't go out?
> Any advice would be greatly appreciated!
>
> Regards,
> Benjamin Pierce
>sql

How to stop running subscriptions??

Is there any way to stop a subscription once it has started?
Does the "CancelRunningJobs.rss" script included in the samples do this?
I have tried searching on here and on google and have not come up with much.
Thanks,
NickI did cancel a long runnig transactions with restarting the SQL Server
agent,
this ended up the Subscription and redering part of about 250 subscriptions.
HTH, JEns Süßmeyer
--
http://www.sqlserver2005.de
--
"Nick P @. INDATA" <NickPINDATA@.discussions.microsoft.com> schrieb im
Newsbeitrag news:152BEDCE-FC64-41DD-905C-B7C8727E441F@.microsoft.com...
> Is there any way to stop a subscription once it has started?
> Does the "CancelRunningJobs.rss" script included in the samples do this?
> I have tried searching on here and on google and have not come up with
> much.
> Thanks,
> Nick