polijob

This table is typically used by Unicenter Asset Management. Each Policy defined in the system usually have several jobs (actions) associated with it. A policy action is usually executed when a Unit becomes member of a policy list (see POLILOG table). The action can range from displaying a scrolling notification text on the Admin Console, appending text to a log or adding the Unit to a group. The actual policy definitions can be found in the POLIDEF table. The DOMAINID and POLID field links them. This table holds the actions attached to each policy. The POLORDER field defines the order of execution for the actions associated with a policy. The POLACT field sets the "execute before" and "execute after" flag. A value of 1 tells that the action should be executed when the policy is met; the value of -1 tells the action is executed when the policy is no longer met and the Unit is removed from the policy member list (see the POLILOG table). The ACTYPE defines the policy type: JOBLINK = 1, NOTIFICATION = 2, MESSAGE =3, TEXTOUTPUT = 4, MAIL = 6, APPLICATION = 8, ADDTOGROUP = 9, DELETEUNIT = 10, EVENTLOG = 11, REMOVEFROMGROUP = 12, NTEVENT = 13, SNMP = 14, TNGEVENT = 16, AHD = 17, SERVICEDESK = 100 ACMEMO defines the action itself. The formatting of the ACMEMO field varies a bit depending on the action type, but generally they are formatted as simple text entry lines separated with newline characters. ACTYPEID is set to 1 if it depends on another action (an example of this is the ACPOL_REMOVEGROUP that is attached to an ACPOL_ADDGROUP action - when you choose to remove the group when the policy is no longer met for the Unit).

Column Name Column Datatype Column Null Option Column Comment
polid integer not null Policy ID. Foreign Key to POLIDEF
polorder integer not null Policy Job Order
polact integer not null Policy Action Schedule (1 = Action to perform when added -1 action to perform when removed)
domainid integer not null Policy domain ID. Foreign Key to POLIDEF
actype integer with null Policy Type.

JOBLINK = 1, NOTIFICATION = 2, MESSAGE =3, TEXTOUTPUT = 4, MAIL = 6, APPLICATION = 8, ADDTOGROUP = 9, DELETEUNIT = 10, EVENTLOG = 11, REMOVEFROMGROUP = 12, NTEVENT = 13, SNMP = 14, TNGEVENT = 16, AHD = 17, SERVICEDESK = 100

actypeid integer with null Additional Action Type ID (0 normal; 1=internal)
acmemo nvarchar(15000) with null Job configuration
auto_rep_version date with null Modification Date. Automatically maintained by Rule. Used for replication.

Product Name: Unicenter Desktop and Server Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.