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 privileges.
You need to ensure that the job step can run using a different user account.
What should you use?
A.
a schedule
B.
an alert
C.
an operator
D.
a proxy
D
D
Check:
https://msdn.microsoft.com/en-us/library/ms175834.aspx