SQL monitor adapter event

The elements contained in the SQL monitor adapter event are different depending on the value for the <single-monitor-event> element defined in the adapter configuration.

Note

To use the data from the monitor adapter event in a triggered process, a Job Input Parameter, inputevent, must be created on the Start activity of the process. The <data> element from the monitor adapter event populates this input. For more information, see Creating rules in the BMC Atrium Orchestrator Platform online documentation.

The following table describes the elements of the SQL monitor adapter when the <single-monitor-event> element is true.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

The following figure shows an XML sample of the adapter event for the SQL monitor adapter when the <single-monitor-event> element is true.

XML sample of the SQL monitor adapter event when the < single-monitor-event > element is true

<sql-monitor-event>
<row>
   <column name="movie_id">1</column>
   <column name="movie_name">Bruce Almighty</column>
   <column name="movie_type">5</column>
   <column name="movie_year">2003</column>
   <column name="movie_leadactor">1</column>
   <column name="movie_director">2</column>
   <column name="movie_running_time">102</column>
   <column name="movie_cost">10</column>
</row>
<row>
   <column name="movie_id">2</column>
   <column name="movie_name">Office Space</column>
   <column name="movie_type">5</column>
   <column name="movie_year">1999</column>
   <column name="movie_leadactor">5</column>
   <column name="movie_director">6</column>
   <column name="movie_running_time">90</column>
   <column name="movie_cost">3</column>
</row>
<metadata>
   <query-executed>select * from movie</query-executed>
   <target-name>target1</target-name>
   <response-row-count>2</response-row-ccount>
   <response-column-count>8</response-column-count>
   <status>success</status>
</metadata>
</sql-monitor-event>

The following figure shows an XML sample of the adapter event for the SQL monitor adapter supporting a stored procedure.

XML sample of the SQL monitor adapter event supporting a stored procedure

<sql-monitor-event>
<response-sets>
   <response-set index="1">
     <out-params>
       <column name="2">2</column>
     </out-params>
     <response-set-metadata>
      <out-param-count>1</out-param-count>
       <has-result-set>false</has-result-set>
       <status>success</status>
     </response-set-metadata>
   </response-set>
</response-sets>
<procedure-metadata>
   <response-set-count>1</response-set-count>
   <query-executed>{call customer_pkg.getCustomerCount(?, ?) }</query-executed>
   <status>success</status>
</procedure-metadata>
</sql-monitor-event>

Note

You can also invoke a function or a stored procedure to return a cursor.

The following figure shows an XML sample of the of the SQL monitor adapter when the <single-monitor-event> element is false.

XML sample of the SQL monitor adapter single event when the < single-monitor-event > element is false

The following table describes the elements of the SQL monitor adapter when the <single-monitor-event> element is false.The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

The following figure shows an XML sample of the adapter event for the SQL monitor adapter when the <single-monitor-event> element is false.

XML sample of the SQL monitor adapter two events when the < single-monitor-event > element is false

<sql-monitor-event>
<row>
<column name="movie_id">3</column>
<column name="movie_name">Grand Canyon</column>
<column name="movie_type">2</column>
<column name="movie_year">1991</column>
<column name="movie_leadactor">4</column>
<column name="movie_director">3</column>
<column name="movie_running_time">134</column>
<column name="movie_cost">15</column>
</row>
<metadata>
<target-name>target1</target-name>
<query-executed>select * from movie</query-executed>
<row-number>2</row-number>
<response-row-count>2</response-row-count>
<response-column-count>8</response-column-count>
<status>success</status>
</metadata>
</sql-monitor-event>

SQL monitor adapter event

On this page