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, ...
