Run as Drop-down is Empty in Job Step Properties

Note: This article assumes that you have already created a Credential and a Proxy mapped to that credential. You have also created a SQL Server Agent Job and you're trying to assign a proxy to a step within that job.

I have read many questions posted on various websites on how to assign a proxy to a particular job. Some of them have described that their "Run as" drop down is empty.




This usually means that they haven't created a proxy. But sometimes, your DBA have created the proxy account, but forgot to grant your user the permission to that proxy account. But unless you have sysadmin role on your account, the proxy will not magically appear on your drop-down. You need to explicitly add the principals that will have access to that proxy. To do that, the sysadmin must use SSMS to go to Object Explorer -> Database Server -> SQL Server Agent -> Proxies -> Subsystem -> double-click the proxy account to open the Proxy Account Properties dialog, click on the Principals page. The right side of the dialog will look like the following.




Click on the Add button to find the SQL Login or role for your user that you want to give permission to this proxy. Once this has been done, the proxy should appear on your Run as drop-down.