What types of functionality does SQL Server Agent provide?

1.	What types of functionality does SQL Server Agent provide?
Answer» SQL Server Agent provides MULTIPLE functionalities LIKE:- SQL Server Agent is a Windows service come with all SQL editions other than express. SQL Server Agent is like task SCHEDULER of OS. It used to schedule jobs/PROCESS & reports. SQL Server Agent is also provided inbuilt features of Alerts like Blocking, deadlock, etc. SQL Server Agent support multiple types of process like T-SQL \ CMD \PowerSheel \ SSAS \ SSIS for scheduled execution. SQL Server Agent provides the proxy option to secure and limit the direct user access on CRITICAL sub-systems.

Answer»

SQL Server Agent provides MULTIPLE functionalities LIKE:-

SQL Server Agent is a Windows service come with all SQL editions other than express.
SQL Server Agent is like task SCHEDULER of OS. It used to schedule jobs/PROCESS & reports.
SQL Server Agent is also provided inbuilt features of Alerts like Blocking, deadlock, etc.
SQL Server Agent support multiple types of process like T-SQL \ CMD \PowerSheel \ SSAS \ SSIS for scheduled execution.
SQL Server Agent provides the proxy option to secure and limit the direct user access on CRITICAL sub-systems.

Discussion