Cisco Cisco Process Orchestrator 3.0

4-29

Cisco TEO Adapter Guide for Microsoft SQL Server Database

OL-24576-02

Chapter 4 Using Microsoft SQL Server Database Activities

Defining the List SQL Server Running SQL Queries Activity

Step 5

Complete the appropriate information in the following tabs, as necessary, and then click the Save

tool to complete the activity definition.

•

Target—Specify whether the defined process target should be used or overridden. See

Step 5

Defining the Bulk Insert into SQL Server Activity

•

Credentials—Specify the runtime user whose credentials should be used to monitor for changes that
will trigger the process. See

Step 6

Defining the Bulk Insert into SQL Server Activity

•

Knowledge Base—Choose the appropriate knowledge base article to associate with the process. See

Step 7

Defining the Bulk Insert into SQL Server Activity

•

Result Handlers—Click the appropriate buttons to manage the condition branches on the workflow.
See

Step 8

Defining the Bulk Insert into SQL Server Activity

Defining the List SQL Server Running SQL Queries Activity

Use the List SQL Server Running SQL Queries activity to query the SQL queries currently running on
the SQL Server database.

To define the List SQL Server Running SQL Queries activity:

Step 1

On the Toolbox pane, under Database - Microsoft SQL Server, select the List SQL Server Running
SQL Queries activity, then drag and drop the activity onto the Workflow pane.

The List SQL Server Running SQL Queries property pages display.

Figure 4-21

List SQL Server Running SQL Queries Properties—General Tab

Step 2

On the General tab, enter the following information:

Field

Description

Display Name

Name of the activity