sql管理ppt課件-資料下載頁
2025-01-09 05:17本頁面
【正文】 l Net send Job 2: Back Up Northwind Transaction Log Pager Pager Schedule 8:01 6:00 . Nwind Admins 6:01 12:00 . Jose Lugo 12:01 8:00 . Meng Phua Threshold Reached at 1:28 . 制定防故障操作員 FailSafe Operator Pager Schedule 12:01 8:00 . Meng Phua 8:01 6:00 . Nwind Admins 6:01 12:00 . Jose Lugo Operator Notification Operators Meng Phua Nwind Admins Jose Lugo Email Net send Pager Alert: Error 18204 Backup Device Failed ?SQL Server 自動化排錯 ? 驗證是否已經(jīng)啟動 SQL Server代理 ? 驗證是否已經(jīng)啟用作業(yè)，調(diào)度，警報或操作員 ? 確保已經(jīng)啟用代理帳戶 ? 查看錯誤日志 ? 查看歷史記錄 ? 驗證郵件客戶程序是否運(yùn)行正常 警報排錯 ? Factors That Cause an Alert Processing Backlog ? Windows application log is full ? CPU use is unusually high ? Number of alert responses is high ? Resolving Alert Processing Backlog ? Disable the alert temporarily ? Increase delay between responses ? Correct global resource problem ? Clear the Windows application log Lab C: 創(chuàng)建警報 ?多服務(wù)器作業(yè)自動化 ? 定義主服務(wù)器 ? Creates MSXOperator on master server and all target servers ? Represents a primary department or business unit ? 定義目標(biāo)服務(wù)器 ? Are assigned to one master server ? Reside in the same domain as the master server 定義主服務(wù)器 Target Server Target Server Target Server Master Server defines jobs Target server downloads jobs from master server 2 Target server reports job oute status to master server 3 1 2 3 Use a Domain User Account That Is a Member of the Windows Local Group Administrators Send Alerts to Email Group Aliases Rather Than to Individuals Define Operators to Respond to Fatal Errors Assign a FailSafe Operator Use Multiserver Jobs to Automate Jobs Across Multiple Servers 推薦練習(xí) 復(fù)習(xí) ? 配置任務(wù) ? 例行 SQL Server管理任務(wù) ? 自動化例行管理任務(wù) ? 創(chuàng)建警告 ? SQL Server 自動化排錯 ? 自動化多 SERVER作業(yè)
公司管理相關(guān)推薦
鄂ICP備17016276號-1