Email reports directly to the hands of your Executives

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Austin Zellner » Email reports directly to the hands of your...

28 posts, Page 3 of 3

«««1 2 3

Email reports directly to the hands of your Executives

Rate Topic

Display Mode

Topic Options

Author

Message

timothyawiseman

Posted Wednesday, June 25, 2008 2:09 PM

Right there with Babe

Group: General Forum Members
Last Login: Thursday, February 14, 2013 12:01 PM
Points: 743, Visits: 900

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

metawizard2

Posted Wednesday, June 25, 2008 6:04 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, July 05, 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

metawizard2

Posted Wednesday, June 25, 2008 6:05 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, July 05, 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

metawizard2

Posted Wednesday, June 25, 2008 6:09 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, July 05, 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

metawizard2

Posted Wednesday, June 25, 2008 6:12 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, July 05, 2011 7:37 PM
Points: 58, Visits: 149

I'm not familiary with sp_makewebtask; what does it do?

Post #523803

Peter Schott

Posted Wednesday, June 25, 2008 9:08 PM

Right there with Babe

Group: General Forum Members
Last Login: Today @ 11:01 AM
Points: 739, Visits: 927

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

Seth-284448

Posted Thursday, June 26, 2008 8:48 AM

Grasshopper

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

sheldonzola

Posted Thursday, June 26, 2008 9:18 AM

Forum 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 »

28 posts, Page 3 of 3

«««1 2 3

Permissions