Forum Discussion
cannot run specific Stored Procedure or corresponding agent job (that is a sysadmin)
*granted user xp_cmdshell, then it complains about not having the proxy set. *My customer doesn't want to configure a proxy. We have several other jobs setup the exact same way with the same user (...
*My customer doesn't want to configure a proxy.
tanyaf55 , then tell your customer, that's not a good idea. Create a proxy account with as less as possible permissions; everything else is a high security risk.
other jobs setup the exact same way with the same user (so it appears)
You can't define a user for plain T-SQL job steps, then SQL Server-Agent account is used.