Tag Archives: SQL Script to Change all SQL Job Owners to SA

SQL Script that changes SQL Jobs Owner to SA

It’s not a good practice to use individual domain user login to run SQL Server Maintenance jobs. SQL Server Maintenance  Wizards has a limitation. Whenever someone check / update SQL Job, SQL Server automatically change the ownership to user domain account. You need to to manually change the ownership back to SA. If you have [...]

SQL Script that changes SQL Jobs Owner to SA for SQL Server 2000 and prior versions

It’s not a good practice to use individual domain user login to run SQL Server Maintenance jobs. The purpose of this script is to change the owner of every job on the server to run under the service id.  This will guarantee that all jobs will run use SA or specified login, regardless of who [...]