Share

Generate Triggers WF Policy

Why required?

1. New WF Policy and wants it to work as per the conditions specified for the policy.

2. Old Policy ,changes in condition

 

Steps:

1. Navigate to "Administration – Server Management -> Jobs" view

2. Click on New.

3. Component/Job = "Generate Triggers"

4. Now, in the Job Parameters applet, you need to provide the following four parameters:

 a) EXEC : TRUE
 b) Remove : FALSE
 c) Privileged User : "Database Table Owner Name"
 d) Privileged User Password : "Table Owner Password

5. Click on Start.

6. After few seconds, refresh the view (by clicking on "Execute Query" button), you will see Execution Server will get assigned to the request and Status changes to "Active".

7. After few minutes, again refresh the record and once the trigger get generated, Status changes to "Success".

3 comments on “Generate Triggers WF Policy”

  1. Abhishek Reply

    If we keep EXEC = False, an sql file will be generated instead of applying the triggers on database. That sql file can be run later.
    Before creating the triggers, we should drop the existing trigger. i,e. Remove = True
    Cheers
    Abhi

  2. Archana Reply

    This article says when we need to Generate Trigger, But what exactly Generate Triggers do internally has not been explained. Can you please explain why we required to generate triggers?

    • Ashish Kr. Bameta Ashish Kr. Bameta Reply

      Generate Triggers required for:
      1. New WF Policy and wants it to work as per the conditions specified for the policy.
      2. Old Policy ,changes in condition.

Leave A Reply

Your email address will not be published. Required fields are marked *

error: Content is protected !!