Overview of 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