Cisco Cisco Process Orchestrator 3.0

Pagina di 106
 
4-42
Cisco TEO Adapter Guide for Microsoft SQL Server Database
OL-24576-02
Chapter 4      Using Microsoft SQL Server Database Activities
  Managing SQL Server Database Activity Definitions
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 
 in 
.
  •
Credentials—Specify the runtime user whose credentials should be used to monitor for changes that 
will trigger the process. See 
 in 
  •
Knowledge Base—Choose the appropriate knowledge base article to associate with the process. See 
 in 
  •
Result Handlers—Click the appropriate buttons to manage the condition branches on the workflow. 
See 
.
Managing SQL Server Database Activity Definitions
The information in this section provide instructions on modifying the activity properties. Use the activity
 
property page to perform the following functions:
  •
Modify activity properties
  •
Inserting variable references
  •
Adding columns to tables
  •
Removing columns from tables
Modifying a SQL Server Database Activity
Modifying a process does not automatically modify an activity. Activity definitions are included in a 
process definition and the activity properties must be modified separately from the process properties. 
Activities can only be modified in the Process Editor. With the appropriate rights from the Operations 
view, the Process Editor is launched when accessing the process properties. 
When user rights are restricted, the Process Workflow Viewer is launched with the properties displaying 
a display-only view after determining that the user cannot edit the activity.
Use database target query timeout
Select this radio button to use the timeout value indicated 
in the database target as the length of time to wait before a 
command is complete.
Override database target query 
timeout
Select this radio button to override the timeout value 
indicated in the database target.
Note
Click the time unit link to change the timed out 
interval (e.g., seconds, minutes, hours, days)
Field
Description