Which SQL Server component should you use?

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?

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.
SQL Server Agent

B.
Notification Services

C.
Service Broker

D.
SQL Mail



Leave a Reply 1

Your email address will not be published. Required fields are marked *