How to find what SQL Jobs are using a specific account as Proxy?
5
votes
2
answers
20094
views
We have identified a few servers that are using Proxy accounts inappropriately. Some of these servers have multiple Credentials and Lots of Jobs. Manually checking the Job Property GUI for "Run As" on each step is not desired.
How can I quickly identify which if any, jobs have steps that are using Proxy Credentials we have identified as inappropriate?
I want to see, the account related to the Proxy. As well as the Job Name and Step the Proxy is used on.
SQL 2008+
Asked by James Jenkins
(6318 rep)
May 5, 2016, 04:57 PM
Last activity: May 6, 2016, 01:31 PM
Last activity: May 6, 2016, 01:31 PM