You administer a Microsoft SQL Server 2012 database.
You have a SQL Server Agent job instance that runs using the service account. You have a job step
within the job that requires elevated permissions.
You need to ensure that the job step can run using a different user account.
What should you use?
A.
A notification
B.
A schedule
C.
A job category
D.
A proxy
D
https://msdn.microsoft.com/en-us/library/ms175834.aspx