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.
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] : /storage/temp/3428-capture.jpg