I have a sql agent job that is called by a cmd file remotely using an admin account for example I will call it OrchestrorService account.
In SQL agent job history I can see the job was invoked by that account.
But the job step actually is a SSIS package. And the step is run using SQL server service account which is another account.
I tried to figure out the permission issue, both the account is a Sysadmin, I want to know which account it runs under in this case,
the SQL server service account, or whoever invoked the account?