Download FactorySQL 4.1 User Manual

 Scheduled Group Options
Scheduled groups read and execute SQL queries This provides a way for users to maintain scheduled SQL queries
external to FactorySQL. For example, you could run a scheduled query to retrieve data from another database
with the days production schedule. Or you could run a query which initiates a database backup.
Inspection Rate: How often the group will check the database to see if
new items are ready to run (have passed their scheduled time). Database Connection, Table Name: Specifies where the group will look
for scheduled items. Column Mapping: Allows you to map the necessary fields to different
names, in case you are trying to use an exisiting table, or otherwise
need different column names. Default values should be fine in most
cases. Evaluation Order: Specifies how items will be executed if more than 1
have expired. In the picture, items will be executed according to their
database index, ascending. Selection Restriction: An SQL "Where Clause" for selecting items. Reschedule For/Delete: After running, items will either be rescheduled
or delete. This setting is mostly a default, as individual items can specify
their own settings. Execute Items as a Transaction: If the database supports it, all active
items will be executed as a transaction , meaning that if one item fails to
execute, all items will be undone. Copyright © 2001-2005 Inductive Automation,Inc. All Rights Reserved.
Page 91