Simplify and automate Microsoft SQL Server scheduling and job execution with Cisco Tidal Enterprise Adapter for Microsoft SQL Server DB. This software works with Cisco Tidal Enterprise Scheduler. You can define any SQL Server job and its dependencies through the intuitive, visual, script-free scheduler interface.
Unlike point tools, with this SQL Server scheduling solution, you can handle SQL Server jobs as part of broader enterprise schedules. Such contextual understanding of a SQL Server job helps you work quickly, decrease lag times, and reduce errors.
This Cisco Tidal adapter increases throughput and reduces the time that complex SQL Server job sequences consume. These sequences include jobs that are maintenance related, are propelled from within Microsoft SQL, or originate in other parts of the enterprise.
Detailed job monitoring and controls
Once database jobs are defined and scheduled, the solution provides real - time status information and gives IT staff the ability to interact with current and future jobs. Users can access detailed job step controls - hold job instances, abort, delete, re - run, and make ad hoc changes to a job instance before it has run. In addition, IT staff has constant communication with SQL Server workflows through the use of extensive alert capabilities which can be defined to send detailed messages regarding job abnormalities, resource availability, load balancing, and machine functions. In addition, Enterprise Scheduler offers different options for displaying job output, including aligned columns, CSV, raw, and XML.
Defining and running SQL server eventsProduct Highlights
Enterprise Adapter for SQL Server simplifies processing database events and does not require scripting or managing database triggers. The adapter give users the ability to capture and respond to database activities, such as table modification, index creation, or database row activity. And Enterprise Scheduler permits views of all runtime database events, which users can then leverage to create events - based job dependencies quickly and efficiently. The adapter can easily pass variables from Enterprise Scheduler to any SQL Server database job, pass job information across the entire batch job scheduling environment, and pass completed SQL Server jobs to other downstream workflow operations, such as extract, transform, and load (ETL) report creation. In addition, specific events - the arrival of a file from a trading partner, for example - can be used to initiate a SQL Server action or job step automatically. Users can also assign alert actions to an event, making it possible for administrators to know when that event has been triggered. Users can assign alerts to the database user who triggered an event, the database object that triggered it, and the output of the event selected.
- Helps define various task types such as direct SQL jobs, existing database jobs, and operating system commands
- Provides real-time SQL job status information and helps staff interact with current and future jobs
- Simplifies processing database events without requiring scripting or management of database triggers
- Offers a single solution for SQL Server scheduling and other enterprise jobs
- Eliminating the creation and management of scripts
- Reducing the need for manual intervention by automating event and alert triggers
- Saving time with out-of-the-box processing steps