PrepAway - Latest Free Exam Questions & Answers

Tag: adding permissions to adam db

which role should you add Adam to allow him to perform these tasks without giving him unnecessarypermissions?

You are the database administrator of your company. The network contains a SQL Server 2008 computer thathas a default instance of SQL Server installed. You want to allow an assistant administrator named Adam to beable to perform the following tasks:
? Execute, start, or stop all local jobs.
? Delete the job history for any local job.
? Enable or disable all local jobs and schedules.
To which role should you add Adam to allow him to perform these tasks without giving him unnecessarypermissions?