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 |
|
Spence23
Starting Member
10 Posts |
 Posted - 2005-05-17 : 11:09:15
|
| Hi,I am currently working on various reports which require a subscription, and I have a request with regards to subscription errors.I was asked if there was a way for someone to be notified by email if one of the subscriptions did not run correctly, for example if the connection to the database failed for some reason and the report never ran and thus the subscription was never completed, is there some sort of way for an email to be sent notifying someone of this error.I know it is logged under the Status field of the subscription, but may not be checked that often.Thanks |
|
|
jhermiz
3564 Posts |
Posted - 2005-05-17 : 13:26:33
|
You can access the reporting db from your sql server, but I generally would be careful with this.A lot of the data may be encrypted so it might be difficult to find what you are looking for.You can even use this data to create a report of all subscriptions that failed, should be simple.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
|
|
|
Subscription Errors