title: How to automate reports and send them to customers in sql server?
body: <p>I have been looking for solution to automate the reports. I have many customers and many reports.
  each customer has their own will to receive individual report on specific day to their given/subscribed email addresses. So I have customer and report name and weekday, weekly, monthly (different schedules) and list of customers where each report is sent to.</p>
  
  <p>Is there any way to implement this automation using simple T-SQL?</p>
  
  <p>I have been able to make report in Crystal report and through command like (use TSQL) to generate report output in any format, lets say, .pdf and based on customer list send them email on their scheduled day.</p>
  
  <p>I do not want to do this all in Crystal Report, because there is already SSRS we have but my question is, Ids there any easy way that i pass a command line to my sql server report and that returns me output so that i can send email to my clients?</p>