Smart Materials allows you to define queries so that you can check the status of the database and generate e-mail alert messages. For example, you can warn a user if the delivery dates of a purchase order have become critical due to winter weather that is preventing a ship from leaving the harbor.
You can define early warning queries and also specify the interval or frequency of execution of the queries. You can assign the queries to users and/or roles and either execute the query in the Definitions page or define a job in the DBMS Jobs page.
What do you want to do?