Define early warning query - Intergraph Smart Materials - 10.2 - Help - Hexagon

Intergraph Smart Materials Web Help (10.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Web
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2
  1. From the Home page, select Administration > Global Setup > Early Warnings > Definitions.

  2. Click Add Row.

  3. Type an alert code and description.

  4. Select an interval from the Interval list.

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

  6. Select Yes from the Active list to activate the early warning query.

  7. Select Yes from the Separate list for the query to be executed using DBMS Jobs page.

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

  8. Select Yes from the Email to activate sending of emails with the alert information.

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

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

  11. Type the subject of the email to be sent in the Email Subject cell.

  12. Type the body of the email in the Email Body cell.

  13. Click Save.

  14. 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.

  15. 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.