Sample Header Ad - 728x90

what is the best approach to send report by Email?

4 votes
2 answers
1412 views
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?
Asked by Racer SQL (7546 rep)
Jul 6, 2020, 12:24 PM
Last activity: Jul 7, 2020, 07:22 AM