When businesses require an enterprise-wide, heterogeneous automated job scheduling solution that incorporates SQL Server workflows, Workload Automation, combined with Tidal Workload Automation Adapter for Microsoft SQL Server, is the right choice. This powerful combination brings the reliability and flexibility of Tidal’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.
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.
The adapter allows SQL Server jobs to be handled through the Tidal 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
Important scheduling capabilities for SQL Server users include:
The adapter can easily pass variables from Tidal Workload Automation 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 new 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.
Tidal Workload Automation Adapter for Microsoft SQL Server helps IT staff deliver maximum database job throughput, rock-solid reliability, and comprehensive coordination of database activities as part of an enterprise- wide business process automation solution. This powerful solution accomplishes these objectives by providing a single integrated enterprise job scheduler that balances the service requirements of batch or on demand workloads, whether they were created from within SQL Server or exist in support of other applications and technologies across the enterprise.
Tidal’s enterprise-wide automation platform transcends the inherent limitations associated with standalone point products or native cloud schedulers. We can automate and orchestrate cross-application workloads and enterprise-wide business processes that traverse multiple clouds and hybrid environments – all from a single-pane-of-glass view.
Tidal helps you optimize the value and performance of your legacy infrastructure while opening new opportunities to leverage next-gen applications and workflows. From pure on-prem to hybrid on-prem and cloud engagements – the answer is Tidal.