oracle lert的定义指南.docVIP

该文档将描述如何利用oracle的alert模块定义一个alert以实现提醒功能。 需求：alert每天向今天过生日的朋友发送生日祝福 范围：该截图为在11.5.10中的结果，其他版本偶不是很清楚，应该大同小异 以Alert manager登录系统 Alert--(define 在application后面选择：Oracle Human Resources 名称为：CUX:每日向当天国生日的同事发送祝福 下面的选项卡中选择：on demand Select statement为： select a.person_id, a.LAST_NAME, a.DATE_OF_BIRTH, a.EMAIL_ADDRESS into p_user_id, p_last_name, p_date_of_birth, p_email_address from apps.PER_PEOPLE_f a where a.PERSON_TYPE_ID = 6 and a.LAST_NAME not like 虚拟% and sysdate a.EFFECTIVE_START_DATE and sysdate a.EFFECTIVE_END_DATE and a.EMAIL_ADDRESS is not null and a.person_id=285; 该SQL为把用户的Id，用户名，生日和email地址找出来，测试的时候可以根据需要设置相应的条件，以避免发送大量的测试邮件。 点击verify ，run，以验证该SQL的正确性 点击alert detail察看output选项是否有值 点击上图中的action Action name为：向当天过生日的同事发邮件，然后点击action detail To属性为：p_email_address Subject和下面的邮件正文可以输入：happy birthday 定义action set 输入集名称为：基于生日的邮件发送 然后点击下面的member选项卡，然后填入“向当天过生日的同事发邮件”为前面定义的action的名称 到这里alert定义就完成了，下面讲一下测试： 1.request -(check 看该请求是否正常执行： 待其结束后收邮件，看alert是否正常执行。 谢谢 胡万军 the oil level to the normal oil level. (2) for the secondary prevention of the leakage of cooling water pipe fittings, valve parts before installation to check ... 4.2 measures to eliminate quality defects of cables cable laying in front of the cable construction, design, supervision and construction units to deliver the design, and drawing the third. Combined the engineering field to find fault, adding omitted items. Because the unit used computer DCS control and adds a great deal of control and signal cables. So you should carefully review, checks for missing physical cable, ready for construction and to verify cable length, specifications, familiar with the cable channel and the device location and bracket cable bracket on the section number. At the time of preparation of the inventory of cable, first of all, the professional carefully study electrical schematics, in accordance with the principle of accounting the cable path cable volume, the nu