top of page

SQL Server Agent - Job ownership

  • Adam Thurgar
  • Mar 1, 2018
  • 1 min read

I often see SQL Server Agent jobs owned by user accounts.

These could be SQL logins or Windows accounts.

I like to have all jobs owned by sa (or whatever you have renamed the sa login to, or if you have disabled sa then whatever account you have created with sysadmin privileges that is not going to get deleted).

The problem with jobs owned by user accounts is that if that user gets deleted from the SQL Server and/or removed from your AD then the job will stop running.

Not good, especially if those jobs are your backups or maintenance.

So follow best practice and change your job owners.


 
 
 

Recent Posts

See All
Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a...

 
 
 
Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response...

 
 
 
Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete...

 
 
 

Comments


bottom of page