DBA > Job Interview Questions > Microsoft SQL Server FAQs

This administrator will own the jobs. Which role

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

This administrator will own the jobs. Which role should you assign?

You are delegating permissions on your SQL Server 2005 server to other adminstrators. You have local, single server jobs on one server that you would like to allow another administer to start, stop, and view the history for, but not delete history. This administrator will own the jobs. Which role should you assign? Answer
SQLAgentUserRole

Explanation
SQL Server 2005 provides 3 fixed roles for the agent service that limit privileges for administrators. The SQLAgentUserRole is designed for local jobs (not multiserver) that allows the member to work with their owned jobs (edit, start, stop, view history) without deleting the history of any job.

(Continued on next question...)

Other Job Interview Questions