Notify Log Table

The Notify Log Table (NotifyLog_tb) contains information about the notification log.

Table 1. Notify Log Table field information
Field Name Type Size Use
NotifyEntryKEY number (long) 4 Unique value that identifies each notification log entry.
NotifyName string 35 Unique name identifying the notification definition.
NotifyAction number (integer) 2 Type of action the notification takes.

0 = operator alert

1 = operator E-mail

2 = operator page

5 = scheduler event

6 = task

7 = stored procedure
NotifyOperator string 255 Windows user ID of the operator who receives the notification.
NotifyMsgText string 255 Text of the notification message.
AuditEntryKEY number (long) 4 Relates to the key of the table for which the audit is indicating activity.
AuditMsgType number (integer) 2 Type of audit message:

3 = external data
DataAuditKEY string 50 Source of the audit message.
SourceID number (long) 4 Type of action the notification takes:

0 = operator alert

1 = operator E-mail

2 = operator page

5 = scheduler event

6 = task

7 = stored procedure
ComponentID number (integer) 2 Windows user ID of the operator defined in the operator table who receives the notification.
MsgID number (long) 4 Type of action the notification takes:

0 = operator alert

1 = operator E-mail

2 = operator page

5 = scheduler event

6 = task

7 = stored procedure
EventID number (long) 4 Event ID to which the audit message belongs. Used to group audit messages generated by related processing.
EventType number (integer) 2 Type of event.
  • 0 = undefined
  • 1 = system event
  • 2 = automated event (scheduler event)
  • 3 = interactive event (user session)
  • 4 = mailbox event
EventName string 50 Textual description of the event.
AuditDateTime

datetime (for SQL)

DATE (for Oracle)

 varies by DBMS Date and time the audit log entry was created.
NotifyDateTime datetime 8 Date and time the notification log was written.
UserID string 255 Windows user ID associated with the application requesting the audit log entry.
MachineName string 31 Name of the machine requesting the audit log entry.
Parm1 through Parm10 string 255 Parameter value that the program formatting the audit message selects at run-time.