To use the automatic execution of early warning queries, you must define a job on the A.60.45 DBMS Jobs screen. For more information, see DBMS Jobs. The value chosen for the interval should be less than or equal to the interval chosen on A.60.10. In the Executed PU field, enter the following statement:
BEGIN
m_pck_ewn.process_warnings;
END;
Then click the Install button to activate the job for scheduled execution. The picture below shows an example.
The software then executes the query and sends the results to users registered as receivers after each interval.
On the A.60.10 screen, you can use the One mail per record check box to define how the messages will be sent. If the One mail per record check box is selected, on the first execution, an e-mail for each record returned is sent to the users. On the second execution, the software checks the previous e-mail, and records that match are not sent again. So, when you register and execute a query for a list of users, for example, at the first execution, you receive a list of all users. From the second execution on, the software sends you a message only when a new user is added.
If the One mail per record check box is not selected, on the first execution, the user receives only one e-mail containing all selected records. On a second execution, the software checks the previous e-mail. If a record has been added, a new e-mail is sent that contains all selected records, including the old ones.