Search here for wide range of results..
Loading
Home » Workflows

How Workflow Policy with Duration Works?

10 July 2009 4 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 Monitor Agent verifies if the record is still in violation and dispatches the record to SR Broker to process it.
5. After that, It processes the record as described in earlier point from (6 – 10)

Post your doubts and comments below

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 if the row had reached its expiration time in the END_TM column.

4. When the record completes its duration, Workflow Monitor Agent verifies if the record is still in violation and dispatches the record to SR Broker to process it.

5. After that, It processes the record as described in earlier point from (6 – 10) of previous post.

<<Goto Previous Part<<


Do post your doubts and comments below…

Read some more similar posts

4 Comments »

  • Gaurav said:

    What do you mean by Workflow policy column voilated? Please elaborate.

  • Admin (author) said:

    This means…..that when you do some insert or update on your BC, and that operation matches the Policy Condition …it runs a workflow.

    So, by Violation of Policy , I mean to say that its condition getting met….

    not sure its a common practice, but in my company i got to know about this terminology, to address this policy condition met.

  • andy george said:

    What do we mean here by ” if the record is still in violation”( Refer Point Number 4)

  • Admin (author) said:

    ” if the record is still in violation” . This means that, your workflow policy conditions are still meeting. Means they have not changed, in the time duration when the policy fired and the current time.
    The record’s values should still satisfy the policy conditions, then only monitor agent picks the record from S_ESCL_REQ table and process it

Leave your response!

Add your comment below, or trackback from your own site. You can also subscribe to these comments via RSS.

Be nice. Keep it clean. Stay on topic. No spam.

You can use these tags:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

This is a Gravatar-enabled weblog. To get your own globally-recognized-avatar, please register at Gravatar.


Verify Code   If you cannot see the CheckCode image,please refresh the page again!