Showing posts with label email. Show all posts
Showing posts with label email. Show all posts

Monday, March 26, 2012

How distribute report to external subscribes?

We need to invoke every evening report for all our customers, and send
to him by email and fax according customer profile.
I read about scheduling and ability to send email but in our situation
it seem more complicated.
I not sure how deal with:
+Invoke report for each subscribe according his profile
+even if i send for all customer the same report, how I make schedule
that invoke the same report for each customer by his ID?
+how make schedule that send to each subcribe by his mail address?
+How I can make schedule to send by Fax (this is can be resolve by
Emailing to some Mail to Fax system, So for now we can ignore this Q)
I'm familiar with .NET and I have some experience to build Window
Services so if SQL Reporting not fit to our goal, I can write some
Service, but I not sure how I can Call to Reporting service to Invoke
for me Report and svae it to some format, withoute dealing with GUI.
In short, i need to invoke report and save it programmatically?I find somthing:
Tutorial: Creating a Data-Driven Subscription
at:
MSDN Library > Enterprise Servers and Development > SQL Server > SQL
Server 2005 Documentation > SQL Server 2005 Tutorials > Reporting
Services Tutorials > Creating a Data-Driven Subscription
from: SQL Server 2005 Books Online
hear the excec link:
http://msdn2.microsoft.com/en-us/library/ms169673.aspx

Wednesday, March 21, 2012

How client program get the events?

I know SQL 2005 notification service can send email, file, HTTP protocol to inform the client program the events.

1) How to implement the HTTP solution? My client program is Java or MFC. A sample is really appreciate.

2) If TCP socket could be listened for the events too?

Thanks a lot.

I don't have or even know of an example where the end subscriber is a client application (although that is a commonly asked question in the forum/newsgroup).

You'll need to create a custom delivery channel to provide this functionality.

You may also want to check out Query Notifications, as that technology may also suit your needs.

HTH...

Joesql

How client program get the events?

I know SQL 2005 notification service can send email, file, HTTP protocol to inform the client program the events.

1) How to implement the HTTP solution? My client program is Java or MFC. A sample is really appreciate.

2) If TCP socket could be listened for the events too?

Thanks a lot.

I don't have or even know of an example where the end subscriber is a client application (although that is a commonly asked question in the forum/newsgroup).

You'll need to create a custom delivery channel to provide this functionality.

You may also want to check out Query Notifications, as that technology may also suit your needs.

HTH...

Joe