Is it possible to recieve a notification when a subscription fails?

Is it possible for me to receive an email notification from SSRS if one of my report data-driven subscriptions fail?

Status of this memo
This document is an Internet-Draft. Internet-Drafts are working documents of the Internet Engineering Task Force (IETF), its areas, and its working groups. Note that other groups may also distribute working documents as Internet-Drafts.

Internet-Drafts are draft documents valid for a maximum of six months and may be updated, replaced, or made obsolete by other documents at any time.It is inappropriate to use Internet-Drafts as reference material or to cite them other than as "work in progress".

To learn the current status of any Internet-Draft, please check the "1id-abstracts.txt" listing contained in the Internet-Drafts Shadow Directories on ftp.is.co.za (Africa), nic.nordu.net (Europe), munnari.oz.au (Pacific Rim), ftp.ietf.org (US East Coast), or ftp.isi.edu (US West Coast).

Distribution of this document is unlimited. Please send comments to theHTTP working group at . Discussions of theworking group are archived at .

Abstract
This specification defines an HTTP notification architecture that transmits notifications between HTTP resources. An HTTP resource could be any object which might need to send or receive a notification, for example a distribution list, buddy list, print job, etc.

Is it possible to have SQL send an email out based on a value in a table?

Hi all,

I'm working on a trouble ticket application and would like to add one more bit of functionality to the system:

When a new trouble ticket is created via the application front end (ASP.NET web application) the system sends an email to an appropiate party indicating that a new ticekt has been issued and needs to be responded to. The user must then log into the system to see the new ticket. The ticket is of course stored in the database (SQL Sever 2000). My question is, whether it is possible to tell SQL server to automatically send emails on a set time interval as long as their are tickets in the database that have a status of new?

ThanksThere is a SQL Server extended stored procedure, xp_Sendmail, that will allow your SQL code to send mail (presuming the SQL Mail agent is configured and running).|||You can also use CDONTS from a stored procedure if you don't have SQL Mail installed - http://support.microsoft.com/view/tn.asp?kb=312839|||Thanks all. I have a procedure that uses CDONTS and it works fine. now I gotta figure out hot to schedule it to run based on a field in a database. But hopefully that should be easy.

Wendell|||Hi

This KB is not anymore available online. Can you provide the details for this?

Cesar|||Here'sanother article on the same topic.

Regards,

Xander

Is it possible to email a reportviewer graph as the email body not as an attachment

I have a page that disaplays a column report in a reportviewer control and the report processing mode is local not server. I was just wondering if its possible to programmatically email this graph as the email body not as an attachment using the system.net.mail classses. The email recepients have MS outlook email addresses.

Thanks in advance.

I still want help on this. And now i'm backing off from sending the report as the email body. It wouldn't hurt if the report is send as an attachment. Please some out there help.

|||

http://www.codeproject.com/csharp/Email_a_PDF_Report.asp