Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Email reports directly to the hands of your Executives Expand / Collapse
Author
Message
Posted Wednesday, June 25, 2008 2:09 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, April 4, 2014 4:40 PM
Points: 751, Visits: 917
Its a very nice article. As several people have already pointed out, it is not the only possible solution, but it looks like a good one. It is similar to something I use currently, though my executives prefer excel on the laptop so that is what they receive.

---
Timothy A Wiseman
SQL Blog: http://timothyawiseman.wordpress.com/
Post #523711
Posted Wednesday, June 25, 2008 6:04 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 5, 2011 7:37 PM
Points: 58, Visits: 149
Seth,
I'm not sure about Blackberry's support for HTML ( maybe someone else could comment ).

For this specific solution, the email is built only of text, so no HTML tags are needed. The centering function makes sure that everything lines up inside the text. Therefore it will work with any email client regardless of HTML support.

Austin



Post #523798
Posted Wednesday, June 25, 2008 6:05 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 5, 2011 7:37 PM
Points: 58, Visits: 149
Seth,
take a look at the second post in the string; there is a great link to an article that shows how to create an HTML email, and it would be relatively easy to integrate in with the solution in this article.

Thanks!

Austin



Post #523799
Posted Wednesday, June 25, 2008 6:09 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 5, 2011 7:37 PM
Points: 58, Visits: 149
I'm not familiar with Reporting Services, so I can't comment on the merits; however, if you are using it successfully then I would be interested in your experience.

One aspect of this solution is that it is designed to fit the small screen real estate of the target device ( specifically the blackberry, but could be tweaked for any ). If you are dealing with devices with larger screen real estate, you could increase the columns, or cut the number of columns for smaller screen devices ( older style verizon phones, text messaging, pagers, etc. )



Post #523802
Posted Wednesday, June 25, 2008 6:12 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 5, 2011 7:37 PM
Points: 58, Visits: 149
I'm not familiary with sp_makewebtask; what does it do?


Post #523803
Posted Wednesday, June 25, 2008 9:08 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:08 AM
Points: 840, Visits: 1,279
Quick note - good solution to sending report-formatted data in SQL 2000. With the number of 2000 installs out there, this helps.

Agreed on using DB Mail to send HTML Formatted e-mail and it's relatively easy to drop data into a table. I prefer Reporting Services' Data-driven subscriptions, but in a pinch DB Mail will work.

And I also agree that execs tend to prefer something pushed to them on a regular basis over anything they have to actively retrieve, no matter how easy it is to retrieve it. It's another step to go through to get the data. Well summarized data in an e-mail is easy to digest and determine if they need more details.



Post #523826
Posted Thursday, June 26, 2008 8:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 30, 2012 9:04 AM
Points: 10, Visits: 74
I didn't realize that the generated email was text. I was confused by the html table displayed under "Pretty" Output in the article. Nice job on the technique. We are on sql 2000, so I will look into this solution.

Thanks,
Seth
Post #524257
Posted Thursday, June 26, 2008 9:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 29, 2010 2:28 PM
Points: 1, Visits: 2
You can also use msdb.dbo.sp_send_dbmail to embed the resultset directly into the body of the email:

EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'SQL Server Agent Mail Profile'
,@recipients = @to_list
,@copy_recipients = @cc_list
,@body = @msg
,@query = 'SELECT source, emplid, fullName AS name,
visaTypeFSA as fsaVisa, visaType as psVisa, reason
FROM fsaAtlasReporting.dbo.tblDataLinkIDsReport'
,@subject = @subject
,@attach_query_result_as_file = 0
,@query_result_header = 1
Post #524295
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse