Cisco Cisco Tidal Enterprise Adapter for zLinux Data Sheet
©2016
Cisco
and/or
its
affiliates.
All
rights
reserved.
This
document
is
Cisco
Public.
6. Cisco Workload Automation Adapter for
Microsoft SQL Server
Microsoft SQL Server
Adapter Overview
Adding SQL Server Processes into Cisco Workload Automation Workflows
When businesses require an enterprise-wide, heterogeneous automated job scheduling solution that
incorporates SQL Server workflows, Workload Automation, combined with Cisco Workload Automation Adapter
for Microsoft SQL Server, is the right choice. This powerful combination brings the reliability and flexibility of
Cisco’s Workload Automation enterprise workflow automation solution to this industry-standard database.
The adapter enables scheduling automation of new or existing SQL Server database job or job steps to be
added to an enterprise-wide scheduling environment. SQL Server jobs can now be integrated into a larger
business process workflow environment managed through a single pane of glass. Database dependencies that
affect job steps can now be managed across the entire enterprise, and IT staff can quickly and easily pass
variables to and from SQL Server database jobs. As a result, application and database automation and
management can be consolidated in one solution, reducing staff effort and expense, while increasing
productivity.
How Cisco Workload Automation Adapter for SQL Server Works
The adapter offers advanced scheduling and monitoring capabilities without scripting, manual intervention, or
changes to SQL Server configuration parameters. Once the adapter is configured, SQL Server jobs are defined
and maintained through the Workload Automation web user interface. This heterogeneous automation solution
provides detailed control of SQL Server jobs through extensive alerts about job abnormalities, resource
availability, load balancing, and machine functions. It also provides real-time status information from a single
console and gives IT operations staff the ability to interact with current and future jobs.
Features and Benefits
The adapter allows SQL Server jobs to be handled through the Cisco Workload Automation user interface.
Users can access SQL Server job information and build workflows through a visual interface that allows them to
define dependencies among SQL Server jobs alone or SQL Server jobs and jobs running on other systems and
applications.