Goal:
Make the user to retrieve an incoming message to their e-mail account containing a report document once in a month.
Problem:
How should I do it?
I strongly believe that I need to use SQL server agent tool to make a scheduling.
Information:
*The report's document is created in SSRS.
*The document's content and data is filtered by two parameter, their full name and today's date. before you send it to their email account.
*Data source is SSAS in SSRS.
*All users is located in a domain.
*The e-mail adress and full name is located in the data mart.