This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

automating annotation creation in DPA when objects are changed in SQL

tjk15 over 7 years ago

I would like to have an annotation automatically created when objects (stored procedures, indexes, etc.) are created or changed.

Does anyone already have a script to do that? Or, just point me to the DPA table(s) I will need to insert, and I can do it myself.

Top Replies

jaminsql over 7 years ago +1

tjk15 , 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…

Parents

0 jaminsql over 7 years ago

tjk15,

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.

CON_EVENTS

COLUMN	ORACLE DATA TYPE	SQL SERVER DATA TYPE	NULLABLE	PRIMARY KEY	DESCRIPTION
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.

Reply

0 jaminsql over 7 years ago

tjk15,

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.

CON_EVENTS

COLUMN	ORACLE DATA TYPE	SQL SERVER DATA TYPE	NULLABLE	PRIMARY KEY	DESCRIPTION
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.

Children

0 stinkycheese65 over 4 years ago in reply to jaminsql

Thanks for that info I have been searching for that table.
Cancel
Vote Up 0 Vote Down

Cancel