1 of 1 people found this helpful
The table is CON_EVENTS. The table does have a DBID column and you would want to make sure that you fill this in with the ID of the monitored instance you want to insert the annotation on.
This would be the ID from the COND table. "SELECT ID, NAME FROM COND;" will give you the ID of your registered monitored instances.
ORACLE DATA TYPE
SQL SERVER DATA TYPE
ID NUMBER BIGINT NO Yes The primary key ID. We will need a primary key generator. DBID NUMBER SMALLINT NO No The ID of the database that this event belongs to from the COND table. EVENT_DATE DATE DATETIME NO No The time of the event down to the minute. This is the DPA server time. TITLE NVARCHAR2(100) NVARCHAR(100) NO No The title of the event. CREATOR NVARCHAR2(50) NVARCHAR(50) YES No The user that created the annotation. DESCRIPTION NVARCHAR2(2000) NVARCHAR(2000) YES No A description of what was done.