Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Email reports directly to the hands of your Executives


Email reports directly to the hands of your Executives

Author
Message
timothyawiseman
timothyawiseman
SSC Eights!
SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)SSC Eights! (802 reputation)

Group: General Forum Members
Points: 802 Visits: 920
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/
metawizard2
metawizard2
Valued Member
Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)

Group: General Forum Members
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



metawizard2
metawizard2
Valued Member
Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)

Group: General Forum Members
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



metawizard2
metawizard2
Valued Member
Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)

Group: General Forum Members
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. )



metawizard2
metawizard2
Valued Member
Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)Valued Member (58 reputation)

Group: General Forum Members
Points: 58 Visits: 149
I'm not familiary with sp_makewebtask; what does it do?



Peter Schott
Peter Schott
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1033 Visits: 1906
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.



Seth-284448
Seth-284448
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 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
sheldonzola
sheldonzola
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search