Loading
Home » Archive

Articles Archive for July 2009

Workflows »

[10 Jul 2009 | 6 Comments | ]

This is for Workflow Policy which has a duration specified -
1. When the workflow policy conditions are violated, a new row gets inserted into S_ESCL_REQ table.
2. Now, if DURATION is specified in Workflow Policy, the Workflow Monitor Agent inserts a new record into the S_ESCL_STATE table and removes the row from S_ESCL_REQ table.
3. Depending on the Sleep Time parameter, Workflow Monitor Agent wakes up and verifies the S_ESCL_STATE table to check whether the row had reached its expiration time in the END_TM column.
4. When the record completes its duration, Workflow …

Workflows »

[10 Jul 2009 | One Comment | ]

Below is a detailed answer to certain questions like –
– What happens when your workflow policy fires,
– how a record get inserted into S_ESCL_REQ ,
– how monitor agent processes the record ??????

Workflow Policy not having a duration specified -
1. When the workflow policy columns are violated, a new row gets inserted into S_ESCL_REQ table by database Triggers.
2. Workflow monitor agent verifies the record in S_ESCL_REQ table and compares if the violated record and matches the Policy Condition.
3. If the conditions are not met, then …