《Alert培训-PCCW-中国移动MIS项目》由会员分享,可在线阅读,更多相关《Alert培训-PCCW-中国移动MIS项目(30页珍藏版)》请在金锄头文库上搜索。
1、Introduction to Oracle Alertcopyqhte orasle aorpordlon 1ggr.200.Alrims rmaved, CFACLE Oracle Alert Process Overview *,Send e-mail message*。,Submit concurrent_w program request*。 Run SQL statement1IE疏|二 What Is an Exception?*。 An exception is a specified condition found duringan alert check-*。 For ex
2、ample, an alert checking for users who did|time finds five users that meetthe criteria. Eachuser found is an exception .二和本*。 Requisition receipt: Informs requesterthatPurchasing received/entered the request本purchase order needs to be approved*。 Database monitoring: Informs DBA when databasetables n
3、eed more space and allocates space if|copylehta orasle corporation 19g7.200.Alrlhs rmened CRACLE Examples of Periodic AlertsPersonnel: Shows all employees that haveterminated in the last six months (monthly)Payroll: Shows current balance and vacationreported by month (monthly)1with nonstandard payme
4、nt terms (weekily)Inventory: Shows when quantity on hand minusquantity ordered is less than reorder quantitywacopyhahte orasle aorpmnaton gr 200.Alrs sevd, CRACLE ie|database event occurs oronce a periodic checking ofthe database has been performed. Oracle Alert canperform these actions:*。 Send an e
5、-mail message*。 Submit a concurrent program request*。 Run a SQL statement scriptETcopyighte oraole corporaton 1ggr.200.Alrim eeved,CORACLE Action Levels*, Detail: Perform the action for each occurrence ofthe condition.*。 Summary: Perform the action fora group ofoccurrences of the condition.本the data
6、base meets the search criteria.2aa Implementation StepsReregisterOracle IDs Configure| concurrent一 managersRequired园 Optionalste Step区 |ELs LasaIT3U* Database User Name* Password本* Install Group*_ Description|忆5System Administrator: (N) Security一DRACLE一RegisterCqpyigte omde Cirpmatbn 1997200 Alrigtrmnetl CRACLE 人Create an electronlc mall account from whlich OracleAlert can send mall.* Defline atleast one electronic mall account astheELaccount ALERT.* Thls mall account ls the sender of messages forwsCmpyithte omde Drpmrdin 19g7200 .Alrigtareered 玫RACLE