© Lisa Bohm 2020
L. BohmRefactoring Legacy T-SQL for Improved Performancehttps://doi.org/10.1007/978-1-4842-5581-0_8

8. Agent Jobs

Lisa Bohm1 
(1)
Chardon, OH, USA
 

SQL Server Agent allows you to set up a schedule to run code at the times you choose. This can be extremely helpful, but can also lead to a very tangled mess. How many times have you heard about periodic slowness in the application or database, but it’s always gone by the time you get online to look for it? You need to determine if there is a real pattern to the slowness, then you can see if there are jobs that coincide with the painful times.

First, let’s look at what the SQL Server Agent should be accomplishing for you. This first section is a bit more administrative than development, ...

Get Refactoring Legacy T-SQL for Improved Performance: Modern Practices for SQL Server Applications now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.