The Polled Statement operation type is
similar to the SQL Statement but has additional functionality that can be used
to co-ordinate pre and/or post processing.
A polled statement is used to execute
an SQL statement or database procedure that returns a result.
The result is then assessed and if the specified condition is meet then
subsequent jobs will be activated.
A typical example would be where you
do not want to begin processing a batch that may consist of many inter-dependent
jobs until the source database table has some data available.
By defining an SQL Statement as “SELECT COUNT(*) FROM TABLE1” and a
polled condition as > 0 then the system will either find some data rows or
time-out after the specified polling interval.