A process control system that automatically monitors processes and
performs activities based on conditions detected during monitoring. The
information needed to do the monitoring and perform activities is
contained in tables in a database system. The process control system may
be configured by configuring entries in the tables. An administrative
query table has records that define administrative queries. Each
administrative query has associated with it a query to be executed on a
table of process records that indicate statuses of the processes being
monitored, a scope that defines a subset of the process records upon
which the query is to be executed, a schedule from which a time of next
execution of the administrative query can be computed, and an activity.
The activity is a set of one or more actions. When an administrative
query is executed and the query associated with the administrative query
is run on the table of process records and the result set is not empty,
the activity is performed with regard to the process records of the
result set. A plurality of activities may be associated with the
administrative query, with the activity to be performed being selected on
the basis of a state of a given process record with regard to the query.