Cisco Cisco Process Orchestrator 3.1 Betriebsanweisung

Use the Cisco Process Orchestrator SQL Server Database Adapter to automate common SQL queries in 
the SQL Server database.

The following table displays activities that are provided by the Microsoft SQL Server database adapter. 
For more information about using these activities, see 

Bulk Insert SQL Server

Enter the source table that will be used to insert data into an SQL Server 
database. 

For more information, see 

.

Check SQL Server Buffer 
HitRate

Query the percentage of pages that were found in the buffer pool without 
having to incur a read from disk.

Check SQL Server 
Database Space

Query the total amount of database space the server is currently 
consuming. 

Check SQL Server Disk 
Space

Query the total amount of disk space the database is currently consuming. 

The result of the query is the amount of available database memory.

Check SQL Server Locks

Display the results of the query for the locks performed in the SQL server 
database.

For more information, see 

.

Check SQL Server 
Memory

Query the total amount of dynamic memory the server is currently 
consuming. 

Check SQL Server Page 
Life Expectancy

Query the number of seconds a page will stay in the buffer pool without 
references.

Delete from SQL Server

Delete data from the SQL server database using SQL command lines.

Enter the command text for the selected database. For example, this is a 
simple DELETE statement:

DELETE from mytable where mycolumn = 'zzz'

Execute SQL Server SQL 
Script

Execute an SQL script against an SQL server database.

For more information, see 

Insert into SQL Server

Insert one database activity into an SQL server database. 

Enter the command text for the selected database. For example, to insert 
values into a table:

INSERT into mytable (column1,column2) VALUES ('val1','val2')