April 2016
Intermediate to advanced
292 pages
6h 25m
English
© Bradley Beard 2016
Bradley Beard, Practical Maintenance Plans in SQL Server, 10.1007/978-1-4842-1895-2_5
Bradley Beard1
(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 ...
Read now
Unlock full access