SQL Server 2008 培训_09+-+chs.pptVIP

Module 6: Automating Administrative Tasks Course 6231A * Explain that automation techniques reduce workload associated with repetitive tasks. The benefits of automating database administration include: Reduced administrative workload, enabling database administrators to focus on other job functions, such as planning database changes or optimizing performance, instead of mundane maintenance tasks. Reduced risk of overlooking vital maintenance tasks, such as failing to rebuild an index or perform a backup. Reduced risk of human error when performing database maintenance tasks. Proactive database management through alerts indicating that action must be taken to prevent problems before they occur. References Automating Administration Across an Enterprise /fwlink/?LinkID=127503 Module 6: Automating Administrative Tasks Course 6231A * Explain that a job is a specified series of operations performed sequentially by SQL Server Agent. We will go into more detail on SQL Server Agents in the next lesson. A job can run Transact-SQL scripts, Command-line applications, ActiveX? scripts, Integration Services packages, Analysis Services commands and queries, Replication tasks. State that jobs can run repetitive tasks or tasks that can be scheduled, and they can automatically notify specified users (known as operators) of job status by generating alerts. You can run a job manually, or you can configure it to run according to a schedule or in response to alerts. You can use SQL Server Management Studio or execute the sp_add_job system stored procedure to define a new job. The job definition is stored in the sysjobs system table in the msdb database. This table is maintained in cache to improve performance. References Implementing Jobs /fwlink/?LinkID=127504 Module 6: Automating Administrative Tasks Course 6231A * Explain that operators are aliases for people or groups that can receive electronic notifications when jobs have been completed. When a job completes, or if any o