Who's credentials are used to "invoke" a scheduled job?

  • can non sysadmins own jobs, and leave the job step's Run As blank

    I am sure I have set this up in the past, but I do not have a suitable environment for testing this right now.

    My recollection is that if the job owner account is also set up as a proxy account for the subsystem needed by the job step, then the step 'run as' can be blank.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply