Cisco Cisco Tidal Enterprise Scheduler 6.2 User Guide
2-14
Cisco Tidal Enterprise Scheduler Microsoft SQL Server Adapter Guide
6.2.1 SP3
Chapter 2 Configuring the Microsoft SQL Server Adapter
Define a Microsoft SQL Connection
Step 7
Select which Microsoft SQL connections that this scheduling user can access when scheduling jobs or
events.
events.
Step 8
Click
OK
to save the user definition.
Define a Microsoft SQL Connection
You must create a connection to the Microsoft SQL instance(s) before Scheduler can run your Microsoft
SQL jobs or monitor database events. These connections also must be licensed before Scheduler can use
them.
SQL jobs or monitor database events. These connections also must be licensed before Scheduler can use
them.
The connection for the Microsoft SQL adapter is defined like other Scheduler connections except it
requires configuration information unique to Microsoft SQL instances.
requires configuration information unique to Microsoft SQL instances.
You can create connections to one or more Microsoft SQL instances and/or databases. Microsoft SQL
access can be managed by limiting a user account to use only certain connections to particular servers.
A connection is created through the
access can be managed by limiting a user account to use only certain connections to particular servers.
A connection is created through the
Connection Definition
dialog.
This dialog contains the following elements:
•
Name
– Enter a name for this Microsoft SQL adapter connection.
•
Enabled
– Activates or disables (deactivates) the connection, shutting down the adapter.