You need to design a database solution that meets the following capabilities:
* Executes SQL Server Integration Services (SSIS) packages
* Executes Transact-SQL Schedules tasks
* Sends alerts
Which SQL Server component should you use?
A.
Notification Services
B.
Service Broker
C.
SQL Mail
D.
SQL Server Agent
Explanation:
SQL Server Agent is a Microsoft Windows service that executes scheduled administrative tasks, which are called jobs. SQL Server Agent uses SQL Server to store job information. Jobs contain one or more job steps. Each step contains its own task, for example, backing up a database. SQL Server Agent can run a job on a schedule, in response to a specific event, or on demand. For example, if you want to back up all the company servers every weekday after hours, you can automate this task. Schedule the backup to run after 22:00 Monday through Friday; if the backup encounters a problem, SQL Server Agent can record the event and notify you.