sql管理ppt課件-在線瀏覽
2025-02-26 05:17本頁面
【正文】 er a master server, and make the production server a target server. Configure the jobs to run on the target server. D. Manually recreate the jobs on the production server. Lab B: 創(chuàng)建作業(yè)和操作員 ?創(chuàng)建警告 ? 利用警報來響應(yīng)潛在的故障 ? 將事件寫到應(yīng)用程序日志中 ? 創(chuàng)建響應(yīng) SQL Server錯誤的警報 ? 創(chuàng)建用戶自定義錯誤的警報 ? 響應(yīng)性能條件的警報 ? 制定防故障操作員 利用警報來響應(yīng)潛在的故障 User Database Email Message From: SQL Server To: Account Manager Subject: Error Number 50099 Customer 732 was deleted by Eva Corets msdb Database Customers Table CustomerID LastName ... 731 Harui ... 732 van Dam ... 733 Niikkonen ... Dam Raise Error 50099 with Log Customer deleted by Eva Corets sysalerts Table id name 15 50099 ... ... sysnotifications Table alert_id operator_id 15 12 ... ... ... ... ... sysoperators Table id name 12 Account Manager ... ... ... ... ... 將事件寫到應(yīng)用程序日志中 ? SQL Server Errors Severity Levels Between 19 and 25 ? sp_addmessage or sp_altermessage System Stored Procedures ? RAISERROR WITH LOG Statement ? xp_logevent Extended Stored Procedure 創(chuàng)建響應(yīng) SQL Server錯誤的警報 ? Defining Alerts on SQL Server Error Numbers ? Must be written to the Windows application log ? Systemsupplied or userdefined ? Defining Alerts on Error Severity Levels ? Severity levels 19 through 25 are automatically logged ? Configure event forwarding 創(chuàng)建用戶自定義錯誤的警報 Create the Error Message ? Error number must be greater than 50000 ? Parameter placeholders can be used Raise the Error from Database Application ? Use the RAISERROR statement ? Declare variables for parameter placeholders Define an Alert on the Error Message 響應(yīng)性能條件的警報 Alert 3 All Databases: Severity Level 18 Alert 2 Northwind Database: Transfer Data Error Alert 1: Northwind Database: Log 75% Full Execute Job: Operators to Notify: Operator Name Meng Phua Nwind Admins Jose Lugo Emai
公司管理相關(guān)推薦
鄂ICP備17016276號-1