Creating and Running the Auditing Triggers Script

After you create and modify all of the trigger statements, you need to create and run the trigger script against the database to create the triggers.

Access the Run Audtrgs page (PeopleTools, and then Utilities, and then Audit, and then Generate Audit Trigger as SQL).

Field or Control Description

Create All Triggers

If you select this check box, the Application Engine writes the Create Trigger statement to a file for every row in PSTRIGGERDEFN.

Create Triggers on

Specify the particular table that the Trigger statement should be created for.

To create and run a trigger script:

  1. Select PeopleTools, and then Utilities, and then Audit, and then Generate Audit Trigger as SQL.

    Add a Run Control ID or select an existing one to access the Run Audtrgs page.

  2. Indicate the triggers that you want to be included in the script, all in PSTRIGGERDEFN or just those that are related to a specific table.

  3. Click Run.

    This process invokes an Application Engine program that writes the Create Trigger statement to a file for every row in PSTRIGGERDEFN that you select (all or for a specific table).

    The system writes the file to the location that is determined by the run location of the process. If it's run on the server, the file is created in the PS_SRVRDIR directory. If it's run on a Windows workstation, the file is created in the directory that the %TEMP% environment variable specifies.

    The file name is TRGCODEX.SQL, where X represents a digit that is determined by the number of files with the same name that already exist in the output directory.

  4. After you create the SQL script, use the native SQL utility to run the script against the database.