1. Queries needs to be ran and data should be exported.
2. Do some calculations on the exported data and create a report with the calculated data
3. send the report through mail
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
So whats your ask? You know what exactly to do, Is there any specific thing you looking for.
Answers Answers and Comments
19 People are following this question.
stop and schedule index maintenance job
SSIS attach file to send email by matching filename with recipient id value from SQL table
Need practical questions to practice DDL,DML and DCL for sqlserver server2012
Need assistance modifying stored procedure SQL Server Management Studio