Skip to Content
Practical Maintenance Plans in SQL Server: Automation for the DBA
book

Practical Maintenance Plans in SQL Server: Automation for the DBA

by Bradley Beard
April 2016
Intermediate to advanced
292 pages
6h 25m
English
Apress
Content preview from Practical Maintenance Plans in SQL Server: Automation for the DBA

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Microsoft® SQL Server 2012 Management and Administration, Second Edition

Microsoft® SQL Server 2012 Management and Administration, Second Edition

Ross Mistry
Professional SQL Server 2012 Internals and Troubleshooting

Professional SQL Server 2012 Internals and Troubleshooting

Christian Bolton, James Rowland-Jones, Glenn Berry, Justin Langford, Gavin Payne, Amit Banerjee
Microsoft® SQL Server 2012 Unleashed

Microsoft® SQL Server 2012 Unleashed

Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Professional Microsoft SQL Server 2014 Administration

Professional Microsoft SQL Server 2014 Administration

Adam Jorgensen, Bradley Ball, Steven Wort, Ross LoForte, Brian Knight

Publisher Resources

ISBN: 9781484218952Purchase book