question

lukjak avatar image
lukjak 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?
jobsaccountscheduling
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

David Wimbush avatar image
David Wimbush answered
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.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
0 Likes 0 ·
Shawn_Melton avatar image
Shawn_Melton answered
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

capture.jpg (205.8 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.