Early Warnings - Intergraph Smart Materials - 10.2 - Training - Hexagon

Smart Materials Web Tutorials

Language
English
Product
Intergraph Smart Materials
Subproduct
Web
Search by Category
Training
Smart Materials/Smart Reference Data Version
10.2
  1. From the Home screen, select Administration > Global Setup > Early Warnings > Definitions and click Add Row.

  2. Type an alert code and description.

  3. Select an interval from the Interval list.

  4. Select the mail content from the Mail Content list.

  5. Select Yes from the following lists:

    • Active list to activate the early warning query.

    • Separate list for the query to be executed using DBMS Jobs screen.

       The query is executed by m_pck_ewn.process_warning(<ALERT CODE>, <PROJ_ID>) in the DBMS Jobs screen. However, the execution of the job is as per the definitions in the DBMS Jobs screen and not as per the definitions in the early warnings Definitions screen.

    • Email to activate sending of emails with the alert information.

  6. Select No in Email per record list to enable sending of all the records in a single mail.

  7. Type a select statement or a PL/SQL query in the Query Statement cell.

  8. Type the subject and body of the email to be sent in the respective cells, and then click Save.

  9. Click Parse Query to check whether the query is a valid PL/SQL query.

    If the query is valid, the application displays a query successfully compiled message else the application displays a message, query compiled with errors.

  10. Click Validate to check the settings required for the automatic execution of early warning queries.

    The application displays the result of the check in the Validation Results block.