Monitoring the Database with PeopleSoft Application Engine

To trigger routings based on a nonuser-initiated event:

1. Write a SQL program that checks the database for data that must be processed.

2. Put the SQL program into an Application Engine program.

3. Use PeopleSoft Process Scheduler to schedule the Application Engine program to run on a regular schedule.

When the condition for which you’re checking is true, the Application Engine program sends the data to the component interface, which initiates a workflow event. After you’ve started the Application Engine program, no user intervention is required.