Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
andros30
Yak Posting Veteran
80 Posts |
 Posted - 2008-10-21 : 17:02:16
|
| I'm need help with queues. The site that supports the product I'm using seems dead without any response to my help. I use sendSAM to send my reports to clients. I have 2 issues with the product when it comes to queuing:1. Sometimes my queue doesn't send out the email. I have two stored procedures that run weekly. The results of each sp gets queued into, say 'MyQueue'. After the second sp is done, it executes the queue and the email goes out with both attachments. This is fine until I have to troubleshoot an issue and I want the results to go only to me. So when I rename the queue to another name, it works...2. I want to give my email a custom subject and message. Currently it sends an email without a subject. This is what I understood was suppose to allow me to do that:@queue_definition parameter let’s you customize default settings stored in defaultQUEUE.xml (found in the QUEUEDefinitions folder) or any other queue definition files that you might have created using SqlAnswersMail Configuration Utility. The two most useful parameters in @queue_definition are title and body that let you specify the subject and body to be used in a consolidated email. For example, the following call will queue two emails until 5:00 PM into one message that will have a subject line of “Sales Report”, and the body of the email will start with a text “This is a sales report for the Western Region”.exec sp_sendSAM @recipients='info@domain.com', @subject='Test Queue', @queue='5:00 PM'exec sp_sendSAM @recipients='info@domain.com', @subject='Test Queue', @queue='5:00 PM', @queue_definition='//queue/@title=Sales Report;//queue/@body=This is a sales report for the Western Region' |
|
|
mahsa_mr
Starting Member
22 Posts |
Posted - 2008-10-22 : 00:57:46
|
| You can Sned your email Via SQL Reporting Servicees |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-22 : 01:24:23
|
quote:
Originally posted by mahsa_mr
You can Sned your email Via SQL Reporting Servicees
How? can you explain that? I've heard you can email through integration services, but havent heard about this functionality in reporting services. or did you meant subscriptions? |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-10-22 : 07:50:08
|
| http://msdn.microsoft.com/en-us/library/ms345234.aspx |
|
|
|
andros30
Yak Posting Veteran
80 Posts |
Posted - 2008-10-22 : 09:57:45
|
| How do I find out if this reporting service is available? I'm only an end user.Edit: I found it... |
|
|
|
|
|
|
Working with queues