principleMinor
what is the best approach to send report by Email?
Viewed 0 times
thewhatemailreportsendapproachbest
Problem
I've been requested to create some sql server reports ( create a report and send them by email ) for some poeple. I thought it would be like 2 or 3 but now that they know I can do it, every week I need to create 1 or 2 more reports.
I use SQL Agent and some steps to create a table, populate with the desired results, then I send it inside a xls file. Thats really not a problem, But I would like to know what can be better used for this task, since now I have more then 20 jobs on my SQL Agent. its all well organized and etc but still, I dont like to be looking at it. I already have a lot of DBA jobs and I dont want to mix things.
Is reporting services a viable way to do this? can I normally create a query, them send it to an excel file and send it by email without using c# or visual studio?
I use SQL Agent and some steps to create a table, populate with the desired results, then I send it inside a xls file. Thats really not a problem, But I would like to know what can be better used for this task, since now I have more then 20 jobs on my SQL Agent. its all well organized and etc but still, I dont like to be looking at it. I already have a lot of DBA jobs and I dont want to mix things.
Is reporting services a viable way to do this? can I normally create a query, them send it to an excel file and send it by email without using c# or visual studio?
Solution
Yes sure.. you can use the subscription and delivery of Reporting Services to send a report.
The available formats are:
(source)
For delivery via email look here.
The available formats are:
- XML file with report data
- CSV (comma delimited)
- MHTML (web archive)
- Microsoft Excel
- TIFF file
- Microsoft Word
(source)
For delivery via email look here.
Context
StackExchange Database Administrators Q#270445, answer score: 5
Revisions (0)
No revisions yet.