You administer a Microsoft SQL Server 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

  Discussion forum


Leave an answer