© Bradley Beard 2016

Bradley Beard, Practical Maintenance Plans in SQL Server, 10.1007/978-1-4842-1895-2_5

5. Cleaning Up SQL Server Agent History

Bradley Beard

(1)Palm Bay, Florida, USA

If you’ve been doing the exercises, you may have noticed that there is a lot of archival data, specifically in the realm of the history of the jobs. This can be both good and bad, depending on your point of view. It can be good because you want to know about the history of your jobs if they fail.

  • If your job always succeeds, then you don’t really need to know about it, except for your own edification.

  • If your job always fails, then you really need to know about it to fix it.

A good way to think about this cleanup task is that this will unclutter the history of your ...

Get Practical Maintenance Plans in SQL Server: Automation for the DBA now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.