asked
SSMS - how to change job caller?
Hi! I've been scheduling some test jobs on server that I usually dont work on. For some reason all jobs are executed using 1 specific account. But this account is neither the system account asociated with SQL Server instance, neither its the account I made the SSIS process with. I've looked through options in SSMS, the package options, job options, server settings. And I cant find place where I could change the job caller. Can anyone help me with this?
I expect it will be the account that's running the SQL Agent service. If this is SSIS jobs, I'm sure you can control which credentials it uses to access data sources via the connection string but I don't know if you can influence how it accesses stuff like folders and files.
I've checked it, it turns out that I accidently checked service accounts on wrong virtual machine. The account that executes jobs IS the account that SQL Server Instance is registered with, and it is also SQL Agent Service account for this particular server. Right now I'm not sure which service should I configure, but at least I know where to look.
Outside of it being the SQL Agent service account, it will be based on how the SQL Agent jobs are configured. If step type is anything but T-SQL you need to check if a proxy is configured. If you are on SQL Server 2012+ and using the SSISDB Catalog then it could be calling the package via T-SQL. In that case check the Advanced tab of the job step and see if "Run as user" is configured. ![alt text][1] [1]: /storage/temp/3428-capture.jpg
19 People are following this question.
