Maintenance Tasks
As a SQL Server DBA, you’ve planned database monitoring and set up maintenance jobs. With various versions of SQL Server, some tasks may be more important than others; something that was a must for SQL Server 2000 might still need to be run in SQL Server 2008, but not as frequently because it’s not as crucial. Oracle versions make a difference as well, especially if your database has older features, such as dictionary-managed tablespaces.
In large database environments, it is not possible to spend all of your time logging in to every database and validating logs and jobs. Automated tasks need to be developed to perform these tasks, and you will want to generate a report or summary to let you know that all systems are looking ...
Get Oracle Database Administration for Microsoft SQL Server DBAs 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.
