Database Automation and MaintenanceUsing Database MailPerforming the Initial Database Mail ConfigurationManaging Database Mail Profiles and AccountsViewing or Changing Database Mail System ParametersUsing SQL Server AgentAccessing Alerts, Operators, and JobsConfiguring the SQL Server Agent ServiceSetting the SQL Server Agent Mail ProfileUsing SQL Server Agent to Restart Services
AutomaticallyManaging AlertsUsing Default AlertsCreating Error Message AlertsHandling Alert ResponsesDeleting, Enabling, and Disabling AlertsManaging OperatorsRegistering OperatorsDeleting and Disabling Notification for OperatorsConfiguring a Fail-Safe OperatorScheduling JobsCreating JobsAssigning or Changing Job DefinitionsSetting Steps to ExecuteConfiguring Job SchedulesHandling Job AlertsHandling Notification MessagesManaging Existing JobsManaging Job CategoriesWorking with Job CategoriesCreating Job CategoriesUpdating Job CategoriesAutomating Routine Server-to-Server Administration
TasksCopying User Accounts, Tables, Views, and Other Objects from
One Database to AnotherCopying Alerts, Operators, and Scheduled Jobs from One Server
to AnotherMultiserver AdministrationEvent ForwardingMultiserver Job SchedulingMultiserver Scheduling RequirementsConfiguring Master ServersConfiguring Target ServersDatabase MaintenanceDatabase Maintenance ChecklistsDailyWeeklyMonthlyAs NeededUsing Maintenance PlansCreating Maintenance PlansChecking Maintenance Reports and HistoryViewing, Editing, Running, and Deleting Maintenance
PlansChecking and Maintaining Database IntegrityUsing DBCC CHECKDBUsing DBCC CHECKTABLEUsing DBCC CHECKALLOCUsing DBCC CHECKCATALOGUsing DBCC CHECKIDENTUsing DBCC CHECKFILEGROUPUsing DBCC UPDATEUSAGE