How to create a report in MS SQL SERVER?

Question

SQL Server

I have a task: once a month to check that some employee is not working, then send a message with his ID to the manager. How to create this job? I'll make a SQL query, but sending a message and making it work constantly from month to month - I still don't know how to create it.

Answer 1

Depends on what
is already in the infrastructure? If there is any reporting, monitoring, mailing - it is better to raise something from this.
- What do you want to study? If you suddenly pick up the database, then MS has Database Mail + sp_send_dbmail .
You can generally connect your SELECT as a data source for Excel and let the manager open and refresh this Excel file once a month.

Answer 2

Install SSRS . Create the necessary report and subscribe the necessary manager to it.